Fast, simple mysql error message?

[Yari]

Hi,

I was wondering if anyone has a fast, informative mysql error script that they use... just trying to optimise my code somewhat.

This is what I currently have:

if (!($result=mysql_db_query(DB, "$sql"))) {
displayErrMsg(sprintf("error getting page select %d:%s\n", mysql_errno(), mysql_error()));
exit();
}

[Shrike]

Do you really want to show everyone your database structure when there is an error? Why not print the error to a log file, and create the ability to switch between screen and log file errors depending on whether the code is in development or 'live'.

[mrhappiness]

the only possible errors i can think of are a f*ed up mysql server which you can't establish a connection to or trying to insert a record leading to primary/unique key conflicts

if no connection is possible output "database server is not available right now. sorry dude"

if inserting a record with an already existing combination of keys (duplicate error) output "sorry, this username is already in use, please choose a different one"

which other errors do you have in mind?