query to sum field

Anon

I am doing a query to sum a field, such as

$T="Select sum(Need_Processed) from Registration";

$result=mysql_query ($T);

At this point, how do I convert the $result to show the actual sum that the query produced. I know I just cant print or echo result, but I am not sure how to convert the results back to the actual integer it is holding.

Thanks,

Paul

tomhath

Just call mysql_fetch_row, pass it $result and assign what it returns to an array; your sum will be in position 0 of the array:

http://www.phpbuilder.com/manual/function.mysql-fetch-row.php

Anon

after your code :

$T="Select sum(Need_Processed) from Registration";

$result=mysql_query ($T);

add this:

$temp = mysql_fetch_array($result);
echo $temp[0];