[snip] I tried the code again and still returns a '0'. It looks like the while() is only looping one record at a time. It does looks like it is add all the records. Do you or anyone have any other suggestions? [/snip]
D'oh! *slaps forehead*! It IS getting only one record! Dang! SELECT SUM(foo) will only return the sum of the column foo...one record! Repost your query and I can help.... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
