connecting to databases

Anon

We have tried this simple script but it still will not connect to the databases even though it has connected to mysql OK.
Is there any obvious reason? Is the script wrong or is it likely that there is a problem with mysql and its configurations?

<body>

<?php

//The values below have been removed for security

$db=mysql_connect($host,$user,$password);

mysql_select_db("test",$db);

$result=mysql_query("SELECT * FROM employees",$db);

printf("First Name: %s \n", mysql_result($result,0,"first"));

printf("Last Name: %s \n", mysql_result($result,0,"last"));

printf("Address: %s \n", mysql_result($result,0,"address"));

printf("Position: %s \n", mysql_result($result,0,"position"));

</body>

This is the type of error that we are getting:

Warning: Supplied argument is not a valid MySQL result resource in xxx/xx/test.php on line xx
First Name:

Please help,

Thank you for your help.
XXX

Anon

do this:

<?php

$db=mysql_connect("hostname","id","passwd");
mysql_select_db("test");

$sql = "SELECT * FROM employees";
$result=mysql_db_query('dbname', $sql);

$num_of_rows=mysql_num_rows($result);

if ($num_of_rows < 1) {
echo 'no records found!';
exit;
}

for ($i=0; $i<$num_of_rows; $i++) {
$record = @mysql_fetch_object($result);

echo "First name: $record->first".' ';
echo "Last name: $record->last".' ';
echo "Address: $record->address".' ';
echo "Position: $record->position".' ';

}