Do some error checking. You're turning off all the errors produced by the mysql
statements, so how
are you supposed to know what's wrong?
You could also try:
$db = mysql_select_db($db_name) or exit(mysql_error());
I'm not sure if mysql_error works for selecting the db, but it couldn't hurt to try :-)
Cheers,
# Nathan
----- Original Message -----
From: "PossumPal" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, June 02, 2002 12:40 PM
Subject: [PHP] mysql_select_db problem
Hi,
I'm a newbie, so please have mercy on my silliness...
I've checked my formats, and can't seem to understand why I can connect to the db, but
not select
the db that I want to use. The following code always returns the "Couldn't select
database" error.
If I use the mysql monitor, I can select the database directly without any problems.
Could someone point out what I'm missing?
<?
$db_name="mydb";
$table_name="my_table";
$connection = @mysql_connect("localhost", "user", "password") or die ("Couldn't
connect.");
$db = @mysql_select_db($db_name) or die ("Couldn't select database");
?>
Regards,
Carol
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php