To a FILE

[bach]

Hello,

I would like to create a function/class (not sure which one appropriate) to log errors to a file.

To start with I would like to create a 'errorlog.txt' file where every mysql error message will be writen so I would be able to check the error log to see if anyone has been having issues login into database, etc.

Now I have the mysql error being displayed as part of my connection but I do not want the user to see this message.

So I would need to store that into a file instead I have no idea on this anyone able to help ?

Bach.

[eves]

wrap your sql query in a function and use this in all your queries
inside the function, perform the query, then test if there were any errors then log them

[code]

function db_query($qry)
{
    $result = @mysql_query($qry);
    if (mysql_errno() > 0)
    {
        // log error to file here
        // and/or perform some error handling
        // you can be creative on this part but be wary of some overheads
    }
    
        return $result;    
    
}
[/code]

[bach]

Thanks for yor reply,

How would I go about writing the log to the file?