list() query not working

Hello,

When I run the code below when $entry = miami.com, I get the following error message:

[QUOTE]

SELECT COUNT(*) FROM #&*+ WHERE `site` LIKE ‘miami.com’:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1

[/QUOTE]

It looks like I’m not correctly defining $table. Any ideas how I could do that?

Thanks in advance,

John

[CODE]$result = mysql_query(“SHOW TABLES FROM feather”)
or die(mysql_error());

while(list($table)= mysql_fetch_row($result))
{
$sqlA = “SELECT COUNT(*) FROM $table WHERE `site` LIKE ‘$entry'”;
$resA = mysql_query($sqlA) or die(“$sqlA:”.mysql_error());
list($isThere) = mysql_fetch_row($resA);
if ($isThere)
{
$table_list[] = $table;
}
}[/CODE]

Also in #PHP _↴