RE: [PHP] Invalid MySQL result resource
| From: | Rasmus Lerdorf | Date: | Thu, 13 Sep 2001 04:51:54 +0000 |
| Subject: | RE: [PHP] Invalid MySQL result resource | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-67126@lists.php.net to get a copy of this message | ||
> $productresult = mysql_query($productquery);
> $productinfo = mysql_fetch_array($productresult); //THIS line produces the error
Well, you don't check for errors. Always always always perform proper
error checking:
$productresult = mysql_query($productquery) or die(mysql_error());
Do that and it will probably be very obvious that your $productquery has
some sort of error in it.
-Rasmus