Syntax Error
Posted: Wed May 24, 2006 8:53 pm
Code: Select all
$bb = "SELECT COUNT (*) AS count FROM ads WHERE (adActive = 1)";
$getcount2 = mysql_query($bb) or die(mysql_error());
while($row2 = @mysql_fetch_array($getcount))
$total = $row2["count"];Any thoughts?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 '(*) AS ct FROM ads WHERE (adActive = 1)' at line 1
-- Abe --