RE: [PHP-DB] MySQL result resource
| From: | John W. Holmes | Date: | Thu, 30 Jan 2003 03:15:33 +0000 |
| Subject: | RE: [PHP-DB] MySQL result resource | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25248@lists.php.net to get a copy of this message | ||
It means your query failed... it always means your query failed for some
reason (unless you typo a variable name...). Learn to use mysql_error()
in conjunction with mysql_query(). Also, like I said before,
mysql_db_query() is depreciated, you should be using mysql_query().
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
> -----Original Message-----
> From: Addison Ellis [mailto:addison@bellsouth.net]
> Sent: Wednesday, January 29, 2003 10:02 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] MySQL result resource
>
> hello,
> i have a new issue... :-)
> i am getting:
> Warning: Supplied argument is not a valid MySQL result resource in
> /users/infoserv/web/register/ca/admin/catads.php on line 54
>
> from:
> <?
> while($row = mysql_fetch_object($obj))
> {
> $scobj = mysql_db_query($dbname,"select * from subcategory
> where id=$row->subcategory");
> $scrow = mysql_fetch_object($scobj);
> $cobj = mysql_db_query($dbname,"select * from category where
> id=$scrow->category");//54
> $crow = mysql_fetch_object($cobj);
> ?>
>
>
> any ideas, of course, are most appreciated. thank you and best,
addison
> --
> Addison Ellis
> small independent publishing co.
> 114 B 29th Avenue North
> Nashville, TN 37203
> (615) 321-1791
> addison@bellsouth.net
> info@smipco.com
> subsidiaries of small independent publishing co.
> info@gloabaldog.com
> info@momandpocentral.com