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