MySql error:S

[jami3]

I have the following code

$hostname='localhost';
$user='jami3EETh'; //'user name for MySQL database';
$pass='********'; //'Password for database'; 
$dbase='membership'; //'database name';

$connection = mysql_connect("$hostname" , "$user" , "$pass") or die ("Can't connect to MySQL");
$db = mysql_select_db($dbase , $connection) or die ("Can't select database."); 

However all of the details being right i get the cant select database error.

Any idears what is wrong??
Thanks

[mrhappiness]

Originally posted by jami3
Any idears what is wrong??

not me but maybe [man]mysql_error[/man] got an idea!!

[jami3]

$hostname='localhost';
$user='jami3EETh'; //'user name for MySQL database';
$pass='******'; //'Password for database'; 
$dbase='membership'; //'database name';

$connection = mysql_connect("$hostname" , "$user" , "$pass") or die ("Can't connect to MySQL");
$db = mysql_select_db($dbase , $connection) or die ("Can't select database."); 
echo mysql_errno($db) . ": " . mysql_error($db). "\n";

Notice i have added

echo mysql_errno($db) . ": " . mysql_error($db). "\n";

However it makes no diffrance to the output of the page

[mrhappiness]

Originally posted by jami3

$hostname='localhost';
$user='jami3EETh'; //'user name for MySQL database';
$pass='******'; //'Password for database'; 
$dbase='membership'; //'database name';

$connection = mysql_connect("$hostname" , "$user" , "$pass") or die ("Can't connect to MySQL");
$db = mysql_select_db($dbase , $connection) or die ("Can't select database."); 
echo mysql_errno($db) . ": " . mysql_error($db). "\n";

Notice i have added

echo mysql_errno($db) . ": " . mysql_error($db). "\n";

However it makes no diffrance to the output of the page [/B]

seems like you don't know what [man]die[/man] does...

$connection = mysql_connect($hostname, $user, $pass) or die ('Connect: '.mysql_error());
$db = mysql_select_db($dbase , $connection) or die ('database: '.mysql_error());  

output?