How to catch mysql_connect errors ?

I would like to prevent mysql_errors from displaying on screen in my
php-pages. The users dont need those, they only need to know in plain
english that there was an error while connecting to the database, I will
then log the the real error to file.
Only part of the code is displayed and a bit simplified (I made a class for
connecting and querying databases) :

This doesnt work (it works OK but the mysql.error message is displayed on
screen before the $ErrMessage)
$LinkID = mysql_connect($arrConnect["host"], $arrConnect["user"],
$arrConnect["pass"]);
if (!$LinkID)
{
$ErrMessage = "Error occured while connecting to database.";
echo ($ErrMessage . "<br>\n");
$ErrLogging = __CLASS__ . " - " . __FUNCTION__ . " - " . $ErrMessage
.. mysql_error();
LogMessage($ErrLogging);
...
When I use mysql_connect or Die() it never reaches the if-statement.

It works OK for mysql_select_db

$Result = mysql_select_db($arrConnect["db"], $LinkID);
if (!$Result)
{
$ErrMessage = "Error occured while selecting database.";
echo ($ErrMessage . "<br>\n");
$ErrLogging = __CLASS__ . " - " . __FUNCTION__ . " - " . $ErrMessage
.. mysql_error();
LogMessage($ErrLogging);
return;
...

It works OK for mysql_query

$Result = mysql_query($sqlquery, $LinkID);
if (!$Result)
{
$ErrMessage = "Error occured while executing query.";
echo ($ErrMessage . "<br>\n");
$ErrLogging = __CLASS__ . " - " . __FUNCTION__ . " - " . $ErrMessage
.. mysql_error();
LogMessage($ErrLogging);
return;
...

thanx,

Pugi!

Pugi! wrote:
 > I would like to prevent mysql_errors from displaying on screen in my
 > php-pages. The users dont need those, they only need to know in plain
 > english that there was an error while connecting to the database, I will
 > then log the the real error to file.
 > Only part of the code is displayed and a bit simplified (I made a class for
 > connecting and querying databases) :
 >
 > This doesnt work (it works OK but the mysql.error message is displayed on
 > screen before the $ErrMessage)
 > $LinkID = mysql_connect($arrConnect["host"], $arrConnect["user"],
 > $arrConnect["pass"]);
 > if (!$LinkID)
 > {
 > $ErrMessage = "Error occured while connecting to database.";
 > echo ($ErrMessage . "<br>\n");
 > $ErrLogging = __CLASS__ . " - " . __FUNCTION__ . " - " . $ErrMessage
 > . mysql_error();
 > LogMessage($ErrLogging);
 > ...
 > When I use mysql_connect or Die() it never reaches the if-statement.

Use @ infront of functions that you want to prevent to make an output to
"html", otherwise you can set a setting in php.ini to not display error
messages in "html", but see to enable error logging, so you have a chance to
see what went wrong.


//Aho