mysql_select_db problem

[Anon]

I am trying to connect from PHP to MySQL. When I issue mysql_select_db("database","userid") I get the following error:

Warning: Supplied argument is not a valid MySQL-Link resource in insert_rec.php on line 16

Has anyone seen this before?

I'd be very grateful for any advice.

[Anon]

Where you have userid, that needs to be the pointer from where you opened the connection to mySQL. You need something like this ...

$db = mysql_connect("$host_name", "$mysql_un", "$mysql_pw");
mysql_select_db("$database", $db) or die(mysql_errno() . ": " . mysql_error() . "<br>");