check for mysql-connection

[Anon]

I'm developing a frontend for mysql in php, and i need to check wether hostname is a valid mysql-connection.

I tried using just mysql_connect($host, $user, $pass), and got error messages printed all over the screen. The function worked for it's purpose, but i want rid of all the errormessages.

It's like this: I want the return 1(true) if selected server(with user and password) is correct, or otherwise if else 🙂

I'm not sure if i'm clear enough in my descibing the problem, but my head is totaly lost in a chaos of code right now....

tnx!

PS! this is a great forum btw, saved me many times 🙂

[Anon]

$dbConn = @mysql_connect($host, $user, $pass);

if ($dbConn) {
// All is well
}
else {
// Ohh crap no database connection
}

The @ symbol supresses error messages.

[Anon]

genious!

tnx a bunch 🙂

[Anon]

Could you help me with another problem currently giving me lost of headaches?

It would would require me to give you access to the source and a demo tour with the frontend.

Just email me if you can help.

[e-mail]

c2

[tburke]

Cato,

try using this, its much better...

$connection = @mysql_connect("db_host", "db_username", "db_password") or die ("couldn't connect database.");

$db = @mysql_select_db(db_name, $connection) or die ("couldn't select database.");

Regards,

Tom Burke