Unable to sum MySQL columns

[acemiller6]

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

[effigy]

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