MySQL result resource
| From: | Addison Ellis | Date: | Thu, 30 Jan 2003 03:02:20 +0000 |
| Subject: | MySQL result resource | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25247@lists.php.net to get a copy of this message | ||
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