Error: Supplied argument is not a valid MySQL result resource
| From: | Internaut | Date: | Thu, 24 May 2001 14:15:17 +0000 |
| Subject: | Error: Supplied argument is not a valid MySQL result resource | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-54224@lists.php.net to get a copy of this message | ||
Hello
I am in the process of learning php by following the examples out of the
book, as I try to run this script an error message appears with the
following:
Warning: Supplied argument is not a valid MySQL result resource in
/home/httpd/vhtdocs/tosh/php/show_more_db.php on line 10
Here is the script:
<?php
//show_more_db.php
include "./common_db.inc";
$link_id = db_connect('sample_db');
$result = mysql_query("SELECT * FROM user", $link_id);
while($query_data = mysql_fetch_row($result)) {
echo "'",$query_data[1],"' is also known as
",$query_data[3],"<P>";
}
?>
Please can you advise further, kind regards Tony