Parse Error on Web Page

PHP MYSQL Parse Error Web Page

Page 1 of 1

1 Replies - 2125 Views - Last Post: 11 May 2005 - 08:24 AM Rate Topic: -----

#1 jetpacmidge  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 11-May 05

Parse Error on Web Page

Post icon  Posted 11 May 2005 - 07:45 AM

Hi

I am new to using PHP and MYSQL and am having trouble with a page which I keep on getting a Parse Error on the last line of the script ????

This is the error message that I get when I try to load up the web page :-

Parse error: parse error in srv/www/htdocs/Tadburn/results2.php on line 134.

Line 134 is the last line of the script.
:rolleyes:
The page is a form which the administrator fills in for entering football results filling in the form either by a pull down menu or fill in the box

Below is a copy of the script :-

<?php
/* Program: results2.php
* Desc: Allows the Administrator to enter the football
* results which updates the tables.
*/
?>
<HTML>

<HEAD>

<TITLE>Results</TITLE>
<STYLE>
<!--
A {text-decoration: none; color:#00008B}
-->
</STYLE>
</HEAD>

<BODY BGCOLOR="FAFAD2" TEXT="00008B" LINK="00008B" VLINK="00008B" ALINK="00008B">
<?php
$user="root";
$host="localhost";
$password="";
$database = "Tadburnfc";

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't select database");

echo "<form action='AddResult.php' method='post'>\n";

echo "<center>\n";
echo " <b><font face='Arial, Helvetica, sans-serif' size='+3' color='#0000FF'>Results</font></b>\n";
echo "</center>\n";
echo "<br>\n";
echo "<br>\n";
echo "<font face='Arial, Helvetica, sans-serif' size='+1' color='#0000FF'>\n";
echo "<p>Enter the football score on the form below !!</p>\n";
echo "<br>\n";
echo "<br>\n";

echo "<font face='Arial, Helvetica, sans-serif' color='#0000FF'>\n";

echo "<table border='0'> \n";
echo "<tr><td align='right'>Season :</td>\n";
echo "<td><input type='text' name='season'
value='$season'
size='7' maxlength='7'> (enter season as 2003/04)</td>\n";

echo " <tr><td align='right'>Fixture Date :</td>\n";
echo " <td><input type='text' name='fixtureDate'
value='$fixtureDate'
size='12' maxlength='12'> (enter date as 2003-mm-dd)</td>\n";
echo " </tr> \n";
echo " <tr><td align='right'>Age Group :</td>\n";

$query = "SELECT DISTINCT age FROM leagueTable ORDER BY age";
$result = mysql_query($query)
or die ("Couldn't execute query.");

echo "<select name='age'>\n";

while ($row = mysql_fetch_array($result))
{
echo "<tr>\n";
extract($row);

echo "<td><option value='$age'></td>$age\n";

echo " </tr>\n";
echo " <tr><td align='right'>Division or League :</td>\n";

$query = "SELECT DISTINCT division FROM leagueTable ORDER BY division";
$result = mysql_query($query)
or die ("Couldn't execute query.");

echo "<select name='division'>\n";

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<td><option value='$division'></td>$division\n";
}
echo "</select>\n";
echo "</tr>\n";

echo " <tr><td align='right'>Home Team :</td>\n";
$query = "SELECT DISTINCT homeTeam FROM leagueTable ORDER BY homeTeam";
$result = mysql_query($query)
or die ("Couldn't execute query.");

echo "<select name='homeTeam'>\n";

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<td><option value='$homeTeam'><td>$homeTeam\n";
}
echo "</select>\n";
echo "</tr>\n";
echo "<tr><td align='right'>Home Score :</td>\n";
echo " <td><input type='text' name='homeScore'
value='$homeScore' size='3' maxlength='3'>\n";

echo "<tr><td align='right'>Away Team :</td>\n";
$query = "SELECT DISTINCT awayTeam FROM leagueTable ORDER BY awayTeam";
$result = mysql_query($query)
or die ("Couldn't execute query.");

echo "<select name='homeTeam'>\n";

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<option value='$awayTeam'>$awayTeam\n";
}
echo "</select>\n";
echo "</tr>\n";

echo " <tr><td align='right'>Away Score :</td>\n";
echo " <td><input type='text' name='awayScore'
value='$awayScore' size='3' maxlength='3'>\n";

echo "</table>\n";
echo "</font>\n";

echo "<p><input type='submit' value='Submit Result'>
<input type='submit' name='newbutton' value='Cancel'>
</form>\n";
?>

</body>
</html>

Any help to resolve my problem would be much appreciated.

Thanks.

Rgds,

Andy M. :music:

Is This A Good Question/Topic? 0
  • +

Replies To: Parse Error on Web Page

#2 Amadeus  Icon User is offline

  • g+ + -o drink whiskey.cpp
  • member icon

Reputation: 248
  • View blog
  • Posts: 13,506
  • Joined: 12-July 02

Re: Parse Error on Web Page

Posted 11 May 2005 - 08:24 AM

You first while loop has an opening brace that does not appear to close anywhere.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1