php获取mysql sum的值,MySQL SUM查询问题php

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);

}