RE: [PHP] Supplied argument is not a valid MySQL result resource
| From: | John W. Holmes | Date: | Tue, 03 Jun 2003 03:15:06 +0000 |
| Subject: | RE: [PHP] Supplied argument is not a valid MySQL result resource | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-149868@lists.php.net to get a copy of this message | ||
> 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?
You're query is failing. Use mysql_error() to find out why (probably
because you need a GROUP BY clause).
---John W. Holmes...
Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/