Hi Everyone, I'm trying to get a very simple "sum" of the values in an MySQL database field column. I have very little experience with PHP and SQL, but I learn quickly. :) Our resident PHP expert who built the full script is really busy, so I've been trying to do this myself. The farthest I could get from just reading various posts in other forums was:
$SelectQuery = new Query ("SELECT SUM(GiftSubscriptions) AS GiftSubs FROM Registration"); $Result = mysql_query($SelectQuery); $Value = mysql_fetch_array($Result); echo $Value['GiftSubs']; However, I'm getting this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource Can someone tell me what's wrong with this part of the code? Thanks, Kurosh -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php