Resource ID# 5 and Resource id #5 8561 errors....help
| From: | Terion Miller | Date: | Fri, 12 Dec 2008 21:54:45 +0000 |
| Subject: | Resource ID# 5 and Resource id #5 8561 errors....help | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-284565@lists.php.net to get a copy of this message | ||
Hey there, okay I ran into these and need some tips, pointers etc...
First I was getting the Resource ID#5 error with this query:
$query="SELECT * FROM importimages WHERE Category='Obits'";
$result = mysql_query($query);
so then I read how mysql_query returns a resource, so I tried this:
$query = "SELECT * FROM importimages WHERE Category='Obits' ";
$result = mysql_query ($query);
$arr = mysql_fetch_row($result);
$result2 = $arr[0];
echo ($result2);
when I echo the result2 I get: 8561 --no idea what the heck that is....
the next line is this and its giving me probs: while ($row =
mysql_fetch_object ($result)) <------that is what it was orginally but it is
not pulling anything out of the db, which led me to echo the query results
(see I am learning finally) so I could see if it really wasn't doing
anything and well its not...and if I try to make an array and then fetch it
as an object it tells me invalid,
I think I'm confused about how to make an object out of an array (if that is
what I want to do) this is pulling images from a db.
Thanks guys!
Terion