mysql_connect() error problem

[andys]

Hi everyone,

The following mysql_connect() string worked with my previous web host but the new host's server which is a cobalt machine reports "No Database Selected"

mysql_connect($hostname,$user,$password) or die("Failure to communicate with database");
mysql_select_db($database);

$query="SELECT * FROM table WHERE ".$checkage." ".$where." order by ID desc" ;
$result = mysql_query($query)
or die(mysql_error());

Any ideas anyone? The new host's support is no help.

[[deleted]]

Hum. if it reports 'no databse selected' it must mean that your mysql_select_db()
Use errorchecking; print mysql_error() whenever a mysql function failes.

[Anon]

everything seems ok in your code, but try to specyfy the resource
$conn= mysql_connect("host","user","pass") or die(mysql_error());
mysql_select_db("dbname", $conn) or die("can not select".mysql_error());

or you may also try:
mysql_query("USE DB_NAME");