warning:supplied argument to mysql_fetch_array not valid resource type?
| From: | Andy B | Date: | Wed, 07 Apr 2004 14:56:13 +0000 |
| Subject: | warning:supplied argument to mysql_fetch_array not valid resource type? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-182646@lists.php.net to get a copy of this message | ||
i have this query set:
$EditQuery="select * from $EventsTable where Id='$edit'";
$query=mysql_query($EditQuery)||die(mysql_error());
//later in the code i have this:
while($old=mysql_fetch_array($query)){
//do stuff
}
when i run the page i get:
warning: supplied argument to mysql_fetch_array is not a valid mysql
resource type on line 98
im lost i wrote this code hundreds of times and it always works... the query
looks right :
echo $EditQuery;
output: select * from rnjresort.events where Id='1'
and that is exactly what i want (i ran that exact string in mysql client)
and it gave me what i was looking for...