php mysql查询在phpmyadmin中工作，但在网页上不起作用

Question

i wrote the following query

SELECT COUNT(userID) From statistics WHERE userID = ""

this query displays the number of unathunticated visit to the website.

the query works in phpmyadmin when i use double quotes however it doesnt when i use single quotes like below it just gives me the number of record stored in the table

 $queryB = "SELECT COUNT(userID) From statistics WHERE userID = ''";
 $resultB =mysql_query($queryA, $con) or die(mysql_error());
 $authB = mysql_result($resultB, "COUNT(userID)");

 echo "the number of authenticated visits were $authB<br />
";

i've no idea why it breaks, any ideas?

Answer 1

not sure if it will work...its just first think that came to mind: how about when u use escaped double quotes?

$queryB = "SELECT COUNT(userID) From statistics WHERE userID = \"\""