Jump to content

Error selecting Data from database


superhoops

Recommended Posts

Here is my code:

[code]
echo '<table border=1 width=100% id=table2>';
while($row = mysql_fetch_array($result)) {
echo '<tr>';
echo '<td>
<p align=left><font face=Arial size=2><font color=#0000FF>
' . $row['Name'] . '</font> - <font color="#FF0000">' . $row['Team'] .

'</font></font></td>';
echo '</tr>';
echo '<tr>';
echo '<td>
<p align=center><font face=Arial size=2>' . $row['Comment'] .

'</font></td>';
echo '</tr>';
echo '<tr>';
echo '<td>
<p align=right><font face=Arial size=2><font color=#006666>
Chance of Winning: ' . $row['Rating'] . '</font></font></td>';
echo '</tr>';
}
echo '
</table>
</td>
</tr>
</table>';

mysql_close($db);
?>
[/code]

Error:

[b]Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/www/fmprotasy.com/precommentsframe.php on line 115[/b]

Line 115 is echo '<table border=1 width=100% id=table2>';

Its probably an easy error but just can't find it.
Link to comment
Share on other sites

[code]
<?php

$db = mysql_connect("username", "username", "password") or die("Could not connect.");
if(!$db)
die("no db");
if(!mysql_select_db("fmpsite_reg",$db))
die("No database selected.");
if(!get_magic_quotes_gpc())
?>
<?php
mysql_select_db('fmprotasy_reg', $db);
$result = mysql_query('SELECT * FROM Pre');

echo '<table border=0 bgcolor=#FF8C00 width=100% cellpadding=10>
<tr>
<td width=100% valign=top style=border-style: solid; border-width: 2>
<p align=left><b><font face=Arial size=2>Pre Match Comments</font></b>
</td>
</tr>
</table>

<table border="0" bgcolor="#FF8C00" width="100%" cellpadding="10" height="15">
<tr>

<td width="100%" valign="top" height="1" style="border-style: solid; border-width: 2">
<font face="Arial" size="2">As the manager you need to say the right things to
win. Here you can rate your chances of success, say a few words to or about the
opposition and prepare your players for the match.<br>
&nbsp;</font><table border="0" width="100%" id="table1">
<tr>
<td width="167"><font face="Arial" size="2">Your Name:</font></td>
<td><form action="insertpre.php" method="post">
<input type="text" name="Name" size="32">
</td>
</tr>
<tr>
<td width="167"><font face="Arial" size="2">Your Team:</font></td>
<td>
<select size="1" name="Team">Team
<optgroup label="Premiership">
<option value="Arsenal">Arsenal<option>
<option value="Aston Villa">Aston Villa<option>
<option value="Birmingham City">Birmingham City<option>
<option value="Blackburn">Blackburn Rovers<option>
<option value="Bolton">Bolton Wanderers<option>
<option value="Charlton">Charlton Athletic<option>
<option value="Chelsea">Chelsea<option>
<option value="Everton">Everton<option>
<option value="Fulham">Fulham<option>
<option value="Liverpool">Liverpool<option>
<option value="Manchester City">Manchester City<option>
<option value="Manchester United">Manchester United<option>
<option value="Middlesborough">Middlesbrough<option>
<option value="Newccastle United">Newcastle United<option>
<option value="Portsmouth">Portsmouth<option>
<option value="Sunderland">Sunderland<option>
<option value="Tottenham Hotspur">Tottenham Hotspur<option>
<option value="West Bromwich Albion">West Bromwich Albion<option>
<option value="West Ham">West Ham United<option>
<option value="Wigan Athletic">Wigan Athletic<option>
<optgroup label="Championship">
<option value="Burnley">Burnley<option>
<option value="Cardiff">Cardiff City<option>
<option value="Coventry">Coventry<option>
<option value="Crystal Palace">Crystal Palace<option>
<option value="Derby">Derby<option>
<option value="Hull">Hull City<option>
<option value="Ipswich">Ipswich<option>
<option value="Leeds">Leeds<option>
<option value="Leicester">Leicester<option>
<option value="Luton">Luton<option>
<option value="Norwich">Norwich<option>
<option value="Plymouth">Plymouth<option>
<option value="Preston">Preston<option>
<option value="Queens Park Rangers">Queens Park Rangers<option>
<option value="Reading">Reading<option>
<option value="Sheffield United">Sheffield United<option>
<option value="Southampton">Southampton<option>
<option value="Stoke">Stoke<option>
<option value="Watford">Watford<option>
<option value="Wolves">Wolves<option></select></font><font size="2" face="Arial">
</font></td>
</tr>
<tr>
<td width="167"><font face="Arial" size="2">Chance of Winning:</font></td>
<td></font><font size="2" face="Arial">
&nbsp;</font><select size="1" name="Rating">Rating
<option value="1">1
<option value="2">2
<option value="3">3
<option value="4">4
<option value="5">5
<option value="6">6
<option value="7">7
<option value="8">8
<option value="9">9
<option value="10">10
</select><b><font face="Arial">/</font><font face="Arial" size="3">10</font></b></td>
</tr>
<tr>
<td width="167"><font face="Arial" size="2">Comments:</font></td>
<td>
<p><textarea rows="5" name="Comment" cols="34"></textarea></p>
</td>
</tr>
<tr>
<td width="167">&nbsp;</td>
<td><input type="submit" value="Submit" name="B1">&nbsp;&nbsp;
<input type="reset" value="Reset" name="B2"></form></td>
</tr>
</table>
<p><br>
<font face="Arial" size="2">Comments by you or other managers:</font><br>
&nbsp;</p>
echo '<table border=1 width=100% id=table2>';
while($row = mysql_fetch_array($result)) {
echo '<tr>';
echo '<td>
<p align=left><font face=Arial size=2><font color=#0000FF>
' . $row['Name'] . '</font> - <font color="#FF0000">' . $row['Team'] . '</font></font></td>';
echo '</tr>';
echo '<tr>';
echo '<td>
<p align=center><font face=Arial size=2>' . $row['Comment'] . '</font></td>';
echo '</tr>';
echo '<tr>';
echo '<td>
<p align=right><font face=Arial size=2><font color=#006666>
Chance of Winning: ' . $row['Rating'] . '</font></font></td>';
echo '</tr>';
}
echo '
</table>
</td>
</tr>
</table>';

mysql_close($db);
?>
<p>
<font face="Arial" size="2"></p>

</font>

</body>

</html>
[/code]
Link to comment
Share on other sites

[code]
echo '<td>
<p align=right><font face=Arial size=2><font color=#006666>
Chance of Winning: ' . $row['Rating'] . '</font></font></td>';
[/code]

This is the kind of code that will make your life Hell later.  I guess it's common practice because PHP allows you to do so, but IMO extending a string onto the next line is bad programming practice.  Some editors will treat the third line of that code as if the variable is inside the string, instead of vice versa.  In other words, some editors get confused and totally screw up the syntax coloring of your source code.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.