$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"];
Firefox tells me this :
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