MySQL SUM query problems php

Question

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.

Community · Accepted Answer · 2017-05-23 12:23:52Z

1

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

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

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.

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Jan 13, 2013 at 1:00

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

lampwins Over a year ago

So is there an easier way to update an old application that has around 5k queries running across about 200 different files?

Vinodkumar SC · Accepted Answer · 2013-01-13 07:24:41Z

0

If you are not using PHP5.5.0, then you can use below way, since mysql_result is deprecreated as of PHP5.5.0

$result = mysql_query("SELECT SUM(`tickets_issued`) FROM `tb_att_registered_attendants` WHERE `confirmation_code`!='000000'");
$ticketTotal = mysql_result($result,0);

answered Jan 13, 2013 at 7:24

Vinodkumar SC

3233 silver badges15 bronze badges

Comments

zavg · Accepted Answer · 2013-05-12 02:01:44Z

0

You can use this solution:

$Row = mysql_fetch_array($ticketTotal);
$sum = $Row['SUM(tickets_issued)'];

I have tested it for my code and it works properly.

edited May 12, 2013 at 2:01

zavg

11.2k4 gold badges47 silver badges68 bronze badges

answered May 12, 2013 at 1:32

mgh

11 bronze badge

Collectives™ on Stack Overflow

MySQL SUM query problems php

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related