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.
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.
11 May, 2005 - 06:45 AM
| 