[thelist] mySQL and PHP troubles

[travis forden]

Hi.

I'm learning mySQL and PHP. I'm working through some examples in the Beginning PHP4 by WROX. I have a mySQL table and I want to use PHP to display the userid and username.

the PHP script is:

<?php
include "common_db.inc.php";  [ specifies db_connect() function ]

$link_id = db_connect('sample_db');
$result = mysql_query("select * from user", $link_id);

while($query_data = mysql_fetch_row($result)) {
     echo "<p>'",$query_data[1],"' is also known as ",$query_data[3],"</p>";
}
?>

[$query_data[1] is the userid; $query_data[3] is the username]

When I run this script, I get the following error:
"Warning: Supplied argument is not a valid MySQL result resource in file.php on line 8"
[line 8 contains the while() function]

Any thoughts on why this is happening? It also happens when I rearrange the script to use mysql_fetch_array(), and mysql_fetch_object().

I'm running MySQL 3.23.32 and PHP 4.0.5.

Thanks,
travis