connect to mySQL database issues

[pulleys]

Hi,

I've been trying all sorts of different ways to connect to my database but keep getting this error:

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource

I talked to my hosting company and they day the database is fine and it must be the php code which they can't support me on. I am quite new with PHP so it is probably me. Here is my code:

<?
$Database = mysql_connect("localhost", "username", "password");
mysql_select_db("mydatabase", "$Database");
?>

I checked my user name and password, both are correct.

Any suggestions? Thanks in advance.

[DJsAC]

remove the quotes around the $Database string in the select.

<?
$Database = mysql_connect("localhost", "username", "password");
mysql_select_db("mydatabase", $Database);
?>

[pulleys]

that worked great, no error.

Thanks you so much. I should buy a PHP book...