Re: mysql_select_db problem

I use the following code for connection and selecting databases: $link = mysql_pconnect("localhost",$_SESSION['dbauser'],$_SESSION['dbapassword']) or die("Could not connect"); print "Connected successfully<P>"; mysql_select_db("stamps") or die("Could not select database"); This works. Regards Peter Goggin ----- Original Message ----- From: "PossumPal" <possumpal@hotmail.com> To: <php-general@lists.php.net> Sent: Monday, June 03, 2002 4:40 AM 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