[Resolved] mysql_select_db problem

[NoBullMan]

Hi,
I am learning, so excuse the simple question:
I can connect to my database in my php code but can't select the database in order to query it.
I was trying to see were it fails and when the code gets to db_connect, it prints the message I put in the mysql_select_db section (i.e. prints "failed in mysql_select_db')

function db_connect()
{
$result = @mysql_pconnect('localhost', 'dbname', '');
if (!$result){
echo 'failed in mysql_pconnect<br />';
return false;
}
if (!@mysql_select_db('dbname')){
echo 'failed in mysql_select_db<br />';
return false;
}
return $result;
}

Can someone tell me what can cause this?

TIA.

[leatherback]

Just to make sure.. IS the name of the database you want to connect to dbname? And you have acces without a password?
Otherwise you have to fill out the proper connection details..?

J.

[NoBullMan]

Thanks a lot for the reply.
I found out that the problem was that I had not issued a GRANT statement (GRANT SELECT, INSERT, DELETE, UPDATE ON dbname.* to dbname@localhost)
Once I did that the problem went away.