Jump to content

Archived

This topic is now archived and is closed to further replies.

acemiller6

Unable to sum MySQL columns

Recommended Posts

From the MySQL prompt I can run the sum function no problem.

 

SELECT sum(apples) FROM kitchen;

 

and this will total the number of apples in the \"apples\" column of the kitchen db. That is working for me no problem. However, when I try to do that from my php code, its not working.

 

$temp = mysql_query(\"SELECT sum(apples) FROM kitchen\", $db);

echo \"Total apples: \". $temp;

 

It prints out to my browser:

 

Total apples: Resource ID #3

 

I know the database is open and it works because if I just try and look at one entry into the database with a select statement it works. So what I am doing wrong? Any help would be much appreciated.

Thanks.

 

Ace

Share this post


Link to post
Share on other sites

queries return resource id\'s which point to arrays. you then need to fetch the elements and loop through them. there are examples on the php site or tutorials here. this is a topic i just replied to, take note of how the information is retrieved:

 

http://www.phpfreaks.com/forums/topic7367.php

 

:D

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.