RE: [PHP] mysql_query won't work!!!
| From: | Jay Blanchard | Date: | Thu, 15 Apr 2004 16:32:37 +0000 |
| Subject: | RE: [PHP] mysql_query won't work!!! | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-183483@lists.php.net to get a copy of this message | ||
[snip]
ok, this same query, works EVERYWHERE ELSE, why won't it work now? it
returns to me:
Warning: Supplied argument is not a valid MySQL result resource
$query_result = mysql_query("SELECT * FROM AotH_Users");
while ($row = mysql_fetch_array($query_result, MYSQL_NUM)){
[/snip]
When are you guys going to learn about error reporting, huh? Try this
(verbose)
$query = "SELECT * FROM AotH_Users";
if(!($result = mysql_query($query, connection_string))){
echo mysql_error();
exit();
}