I have the following query running in PHP:
$ticketTotal = mysql_query("SELECT SUM(`tickets_issued`) FROM `tb_att_registered_attendants` WHERE `confirmation_code`!='000000'");
But when I return $ticketTotal, I get Resource id #33 and when I dump the variable, I get resource(33) of type (mysql result). When I run the exact same query in phpMyAdmin, I get the correct result. I can't seem to find much on google. What is going on?
Thanks in advance for any help.
解决方案
$ticketTotal doesn't hold your query results. You still have to actually fetch them.
while ($row = mysql_fetch_assoc($ticketTotal))
{
print_r($row);
}