neat end if Database failure ?

[baffled_in_UK]

Hi,

I want to redirect if the connection to my Db fails.
I have this code but it doesn't work (or else I wouldn't be here 🙂 ), it just shows the standard SQL errors with no redirection.

Can anyone put me right please ?

<?php $db = mysql_connect("localhost", "user", "password");
 mysql_select_db("database",$db) 
or 
header('Location: http://www.site.com/error.php'); 
?>

Thanks

[IceD]

$db_=_@mysql_connect("localhost",_"user",_"password") or header("Location: xxx.xxx");
@mysql_select_db("database",$db) or header("Location: xxx.xxx");

Note "@"!

[baffled_in_UK]

Sorry to be thick 🙂... but your code gives me a parse error.

Do I need the underscore after $db and before @ and before my user and password ?

Thanks for your help IceD

[hand]

<?php $db = @mysql_connect("localhost", "user", "password");
 @mysql_select_db("database",$db) 
or
header('Location: http://www.site.com/error.php]'); 
?>

[IceD]

Blah - the bug on the forum: when you copy and paste PHP-marked code it inserts underscores 🙁