Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )

Advanced DNS Management
New ZoneEdit. New Managment.


Sign Up Now
> Parse Error On Web Page, PHP MYSQL Parse Error Web Page
post May 11 2005, 07:24 AM
Post #1

Whats this Lie-nix Thing?

Group: Members
Posts: 4
Joined: 10-May 05
Member No.: 4,979


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 :-

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


A {text-decoration: none; color:#00008B}

<BODY BGCOLOR="FAFAD2" TEXT="00008B" LINK="00008B" VLINK="00008B" ALINK="00008B">
$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'
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'
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";

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

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))
echo "<td><option value='$division'></td>$divisionn";
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))
echo "<td><option value='$homeTeam'><td>$homeTeamn";
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))
echo "<option value='$awayTeam'>$awayTeamn";
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'>


Any help to resolve my problem would be much appreciated.


Go to the top of the page
+Quote Post
Start new topic
post May 11 2005, 11:54 AM
Post #2

Its GNU/

Group: Support Specialist
Posts: 1,807
Joined: 23-January 03
Member No.: 360

Is this an exact copy of your script? I've found lots of errors.
Make sure all variables have a $
There are several instances of the following

In addition make sure there is a ; and the end of each php line.

If the n at the end of the lines is supposed to be a newline character then it should be a n. I see it on some lines where it isn't required.

I found several of these errors too:
echo " <td><input type='text' name='awayScore' "; <--needs

Go back and look at each line in your script for errors.
Go to the top of the page
+Quote Post

Posts in this topic

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


RSS Lo-Fi Version Time is now: 22nd April 2018 - 01:49 AM