no database selected

[kingsol]

Ok here is the problem, on my local box, I have a testing server running apache, php, mysql. On my hosting server, same setup.

The following code works great on the remote server, but I get an error "No Database Selected" on my local box when testing.

Any Ideas? Thanks in advance!

Here is the code...

<?
//Database infromation
$hostname_Conn = "localhost";
$database_Conn = "database";
$username_Conn = "user";
$password_Conn = "password";
$Conn = mysql_pconnect($hostname_Conn, $username_Conn, $password_Conn) or die(mysql_error());
mysql_select_db($database_Conn, $Conn);

//check to see if first session
$check_query = "SELECT * FROM table WHERE column = '" . $SessionID . "'";
$check = mysql_query($check_query, $Conn) or die("Check Query: " . $check_query . " -- " . mysql_error());
$totalRows_check = mysql_num_rows($check);
?>

[hand]

mysql_select_db($database_Conn, $Conn) or die(mysql_error());

to get further informations

[Svarog]

to list all databases

mysqlshow -u root -p your_password

in case that you don't have database called "database", execute following

mysqladmin -u root -p your_password create database

[kingsol]

Thanks for both your help...turns out it was permissions of the user in MySQL on my box.

Mucho Gracias.