online reference to mysql_errno() codes?

[Will Woodhull]

I want to do something like this:

while(false == ($result = mysql_query($query)) ) {
switch(mysql_errno()) {
case $fixableError[0]:
case $fixableError[1]:
/* fix the errors */
break;
default:
die ("Fatal error in '$query': " . mysql_error() );
break;
}
}

But I haven't found a satisfactory reference to the error codes. My
googling has returned tonnes of references to files in the PHP source,
but I'm not willing to download the source files and I doubt that
they'd have the kind of error descriptions that would be useful (like,
suggestions on how to avoid the error).

So can someone supply an address to a reference list of these error
numbers?

Also, would the syntax in the "while" clause above work in PHP?

TIA,
Will

[Mario B.]

05.08.2005 18:26:27 Will Woodhull je napisao/la:

I want to do something like this:

while(false == ($result = mysql_query($query)) ) {
switch(mysql_errno()) {
case $fixableError[0]:
case $fixableError[1]:
/* fix the errors */
break;
default:
die ("Fatal error in '$query': " . mysql_error() );
break;
}
}

this is why "try, case, exception" is needed, but i don't miss it one bit
in php :)

--
http://mariob.blog.hr/

[Will Woodhull]

Thanks for the reply, Mario. Though I don't understand the relevance of
your remark.

Mario B. wrote:

05.08.2005 18:26:27 Will Woodhull je napisao/la:

I want to do something like this:

while(false == ($result = mysql_query($query)) ) {
switch(mysql_errno()) {

<snip>
this is why "try, case, exception" is needed, but i don't miss it one bit
in php :)

I know I could use PHP's try...catch construction but it seems like
overkill in the simple code I'm developing. And I think I would still
need to identify the error codes, so a reference list would still be
useful?

Maybe I'm missing something?

[Dana Cartwright]

"Will Woodhull" <wi**@thornhenge.org> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

I think I would still
need to identify the error codes, so a reference list would still be
useful?

A quick Google turned up (as the first hit):

http://dev.mysql.com/doc/mysql/en/error-handling.html

[Will Woodhull]

Dana Cartwright wrote:

A quick Google turned up (as the first hit):

http://dev.mysql.com/doc/mysql/en/error-handling.html

Thank you very much! This looks like it is what I need.

I'm going to go off into a corner now, and deal privately with the
embarrassment of having somehow managed to screw up on using Google...