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