[SOLVED] Parse Error Message

[ArizonaJohn]

Hello,

 

I'm trying to use the code below to echo all tables in the database "feather" that have a row with $entry in the "site" column, and then what value each table has for the column "votes_up" for $entry.

 

I'm getting an error for the line

if(mysql_num_rows($resA) > 0)

.  The error says:

Parse error: syntax error, unexpected ';'

. 

 

Any ideas how I can fix it? 

 

Thanks in advance,

 

John

 

$result = mysql_query("SHOW TABLES FROM feather") 
or die(mysql_error()); 

while(list($table)= mysql_fetch_row($result))
{
$sqlA = "SELECT `site`,votes_up FROM `$table` WHERE `site` LIKE '$entry'";
$resA = mysql_query($sqlA) or die("$sqlA:".mysql_error());
if(mysql_num_rows($resA) > 0)
{
$table_list[] = $table;
while($rowA = mysql_fetch_assoc($resA))
  {
  $votes_up[$rowA["site"]] = $rowA["votes_up"];
  }
}
}

foreach( $table_list as $key => $value){
    echo "$value <br />";
}

foreach($votes_up as $site => $vote_up)
{
  echo "$site: $vote_up";
}

[Cosizzle]

try

 

if(mysql_num_rows($resA) == 0)

[wildteen88]

I guess you have copied and pasted the code from somewhere. All instances of > need to be changed to '>' (without then quotes)

 

> is invalid PHP syntax.

[ArizonaJohn]

OK, thanks.  That helps.

[pkedpker]

doesnt mean he copied and pasted it.. just because it has > character entity I use all the time é in my html code because if you just put é (which means é) it will turn into a Box but otherwise it comes out as a nice é  no idea why that happens but it must be a bug with Google Chrome.