RE: [PHP] error message while mysqling on php
| From: | Murray @ PlanetThoughtful | Date: | Tue, 13 Sep 2005 21:04:55 +0000 |
| Subject: | RE: [PHP] error message while mysqling on php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-222293@lists.php.net to get a copy of this message | ||
> I have received an error: Warning: mysql_num_rows(): supplied argument is
> not a valid MySQL result resource in /home/www/mksystem.net when trying to
> execute $num = mysql_num_rows($result);
>
> Please go to http://mksystem.net/phpinfo.php and tell me
> whether it is due
> to the version of php I have on server and an easy workaround would be
> appreciated.
Check the syntax of your SQL statement, it's very possible you have an error
in it somewhere. If you have PHPMyAdmin, or some other interface to MySQL
such as MySQL Query Browser, etc, try executing the SQL statement in one of
them directly, to see if they return a valid resultset.
Much warmth,
Murray
---
"Lost in thought..."
http://www.planetthoughtful.org