MySQL SUM查询问题的PHP [英] MySQL SUM query problems php

问题描述

我在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'");

但是当我返回$ticketTotal时，我得到Resource id #33，而当我转储变量时，我得到resource(33) of type (mysql result).当我在phpMyAdmin中运行完全相同的查询时，我得到正确的结果.我似乎在Google上找不到很多.发生了什么事?

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?

在此先感谢您的帮助.

推荐答案

$ticketTotal不保存您的查询结果.您仍然必须实际获取它们.

$ticketTotal doesn't hold your query results. You still have to actually fetch them.

while ($row = mysql_fetch_assoc($ticketTotal))
{
    print_r($row);
}

请不要在新代码中使用mysql_*函数.它们已不再维护并已正式弃用.看到红色框?了解有关 准备好的语句 的信息，并使用 MySQLi -本文将帮助您确定哪一个.如果您选择PDO，这里是一个很好的教程.

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

这篇关于MySQL SUM查询问题的PHP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！