in the develop stage, how to have all mysql errors echoed automatically?

[searain]

in the develop stage, how to have all mysql errors echoed, same as echo mysql_error(), automatically for the whole site? then in the finished product, i will just turn it off.

Instead of i add mysql_error() manually in the php pages, and delete them later on in the finished products?

Thanks!

[lucasrd]

This probably doesn't answer your question, but when I write apps, I always use a dababase abstraction class...that way every query always passes through one central location and doing things like that is much easier....

[bpat1434]

Good thought Luc. I too have started using this method; however, I use simple functions. But in that function I check to see if a variable value ($mysql_debug) is set to TRUE. If it is, then I automatically parse the error; otherwise I will just go on without showing any errors.

The $mysql_debug value is set in my config file.

Luc: what's your DB class look like, or any tips on where to find the best way to create one?

~Brett

[goldlikesnow]

If you are on a shared server the easiest way is to add '@' before your php mysql functions

example:

$conn = @mysql_connect("localhost", ".......