Display server error

[Bob Sanderson]

Is there a way, using PHP, to detect and display an error from a MySQL
server? Can I, by using error numbers or some similar method, create my own
error messages?

tia

[Janwillem Borleffs]

Bob Sanderson wrote:

Is there a way, using PHP, to detect and display an error from a MySQL
server? Can I, by using error numbers or some similar method, create
my own error messages?

Sure, you can suppress the error message by preprending an at sign "@" to
the mysql_* function call and get the error code from the string returned by
the mysql_error() function.

Afterwhich, you can use the list of error codes from the MySQL website to
map the error code to whatever you like.
JW

[Janwillem Borleffs]

Janwillem Borleffs wrote:

Sure, you can suppress the error message by preprending an at sign
"@" to the mysql_* function call and get the error code from the
string returned by the mysql_error() function.

That should be: the mysql_errno() function.
JW

[Jerry Stuckle]

Bob Sanderson wrote:

Is there a way, using PHP, to detect and display an error from a MySQL
server? Can I, by using error numbers or some similar method, create my own
error messages?

tia

You can get the MySQL error number with mysql_errno() and the text with
mysql_error(). Then just display whatever text you wish.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================