connecting to a MySQL database

Anon

I have recently begun to use MySQL on a unix platform using PHP and I am having trouble connecting to the databases. I am able to connect to MySQL OK but get an error message saying the PHP script is unable to access the database. I have tried using very simple scripts and have had expert help on PHP scripts but still no joy. I am beginning to think that the problem lies in MySQL. I have given myself all access rights so this should not be the problem. ANY suggestions would be more than welcome.

The error message is:

Supplied argument is not a valid MySQL result resource in XXXXXX on line XX

The script below is what we have been using.

<?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".'<BR>';
echo "Last name: $record->last".'<BR>';
echo "Address: $record->address".'<BR>';
echo "Position: $record->position".'<BR>';

}

Anon

the line:
$result=mysql_db_query('dbname', $sql);

should have been changed from 'dbname' to your database's name. i.e. from above script in line:
mysql_select_db("test");

i can see the db name is test, so use it in above line too. i.e.

$result=mysql_db_query('test', $sql);

Anon

Thanks for the reply. We did change the name of the database but pasted in the old code into the message.
Any more suggestions would be most appreciated.

Anon

I have had the same problems with code that is almost exactly same as what was posted. I have changed a lot of code and come to think is is a bug or something. There is no reason why it shouldn't work and the code I am using did work in previous versions of php. I am at my rope's end trying to figure it out and am now pursuing a different but similar way of doing what i need with out the use of mysql_num_rows being used. Please, if someone knows how to fix this will you mail me also!

Thanks,
Mark