Error Logging with MySQL?

Anon

Hi,

Is there a way to log errors in MySQL with PHP and automatically send me an email whenever a MySQL_QUERY fails?

I currently use this:

MYSQL_QUERY($action,$db) OR DIE(send_em());

But ideally I need to have the page still output to the browser and thus I need to get rid of the DIE part?

Is there something I can do to call a function that will send me an error email through PHP whenever a MYSQL_QUERY fails without using the DIE() function?

Thanks!!!

Anon

Just remove the DIE() from around your function call. All you are doing is saying if the mysql_query fails then do this other function, currently that function is DIE() which then calls your send_em() function, so if you remove the DIE() then you will be fine. Just make sure you write the rest of your page to still display even with the data from the query, or without any database connection.

Anon

I currently use this method:

//Have a query
$query = "Select * From Table";
//Query it
$result = mysql_query("$query");
//Then I copy the query cuz on my system it truncates the results to 0
$result_copy = mysql_query("$query");

//Then I fetch it from an array like so
if (! mysql_fetch_array($result_copy))
{
//insert code for the part where you turn up no results, fails, etc, etc
}

else
{
//insert code for the part where the query is successful
}

This is good if you have no results and do not want any warnings or errors popping up.

Anon

In response to:

"..if you have no results and do not want any warnings or errors popping up..."

you could also do it this way:

if (!$result = @("$sql"))
{
    //do error handling

};