Supplied argument is not a valid MySQL result resource
| From: | Kurosh Burris | Date: | Tue, 03 Jun 2003 02:54:53 +0000 |
| Subject: | Supplied argument is not a valid MySQL result resource | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-149865@lists.php.net to get a copy of this message | ||
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