unexpected $

[MannyLS]

I tried to figure if there was an unclosed tag or something but I can't find it. Here's the code (removed pw) 😉
parse error, unexpected $ in /home/mannylsc/public_html/LPlayers.php on line 138

$db = mysql_connect ("localhost", "mannylsc", "****");
mysql_select_db("mannylsc_mannyleague",$db); 
$result = mysql_query("SELECT * FROM LPlayers",$db); 
$returned=mysql_num_rows($result); 
echo("<p><center><H2><font color=#FFFFFF>Links Online Tour Players</font> <b>$query</b></H2></center></p>\n"); 
/* Lets fetch them and display them in a table */ 
if ($returned>0) { echo("<b>$returned players<br /></b>\n"); 
echo ("<table bgcolor=#000000 bordercolor=#cccccc align=\"center\" cellpadding=1 cellspacing=2>"); 
echo ("<tr><th class=TableHeader>Player</th><th class=TableHeader>Name</th><th class=TableHeader>Nickname</th><th class=TableHeader>country</th><th class=TableHeader>email</th><th class=TableHeader>gmt</th><th class=TableHeader>icq</th><th class=TableHeader>other</th><th class=TableHeader>swing</th></tr>\n"); 

// This gets every returned row, and puts each in a hash 
while($row=mysql_fetch_array($result))
{ echo("<tr>"); 
echo("<td class=TableBody>".$row["player"]."</td>"); 
echo("<td class=TableBody>".$row["name"]."</td>"); 
echo("<td class=TableBody>".$row["nickname"]."</td>"); 
echo("<td class=TableBody>".$row["country"]."</td>"); 
echo("<td class=TableBody>".$row["email"]."</td>");
echo("<td class=TableBody>".$row["gmt"]."</td>"); 
echo("<td class=TableBody>".$row["icq"]."</td>"); 
echo("<td class=TableBody>".$row["other"]."</td>"); 
echo("<td class=TableBody>".$row["swing"]."</td>");


 

I would greatly appreciate your help

[alanzhao]

You missed the if and while closing tag. Both!

<?php 

$db = mysql_connect ("localhost", "mannylsc", "****"); 
mysql_select_db("mannylsc_mannyleague",$db); 
$result = mysql_query("SELECT * FROM LPlayers",$db); 
$returned=mysql_num_rows($result); 
echo("<p><center><H2><font color=#FFFFFF>Links Online Tour Players</font> <b>$query</b></H2></center></p>\n"); 
/* Lets fetch them and display them in a table */ 
if ($returned>0) 
{ 
  echo("<b>$returned players<br /></b>\n"); 
  echo ("<table bgcolor=#000000 bordercolor=#cccccc  align=\"center\" cellpadding=1 cellspacing=2>"); 
  echo ("<tr><th class=TableHeader>Player</th><th class=TableHeader>Name</th><th class=TableHeader>Nickname</th><th class=TableHeader>country</th><th class=TableHeader>email</th><th class=TableHeader>gmt</th><th class=TableHeader>icq</th><th class=TableHeader>other</th><th class=TableHeader>swing</th></tr>\n"); 

// the first missing tag
}

// This gets every returned row, and puts each in a hash 
while($row=mysql_fetch_array($result)) 
{
  echo("<tr>"); 
  echo("<td class=TableBody>".$row["player"]."</td>"); 
  echo("<td class=TableBody>".$row["name"]."</td>"); 
  echo("<td class=TableBody>".$row["nickname"]."</td>"); 
  echo("<td class=TableBody>".$row["country"]."</td>"); 
  echo("<td class=TableBody>".$row["email"]."</td>"); 
  echo("<td class=TableBody>".$row["gmt"]."</td>"); 
  echo("<td class=TableBody>".$row["icq"]."</td>"); 
  echo("<td class=TableBody>".$row["other"]."</td>"); 
  echo("<td class=TableBody>".$row["swing"]."</td>"); 

// the second missing tag
}


?> 

[cgraz]

Is this all your code? There aren't 138 lines there. And besides, you have no closing brackets on your if statement or your while loop, so either that isn't all the code, or that's one more thing you have to fix.

And also, please use the boards php tags when posting php code. IT should look like this:

[ p h p ] put your php code here [ / p h p ]

(minus the spaces). It makes your code more readable.

Cgraz

[MannyLS]

Thanks so much guys. I'm a newbie with PHP (started 2 days ago) and I find it great.
I will remember to use the PHP tags next time:rolleyes:

[Mordecai]

You can edit your post and put the [php] tags in at any time.