Re: [PHP] mysql_errno codes

2003-06-17 Thread Don Read

On 16-Jun-2003 Thomas Hochstetter wrote:
 Hi.
 
 [3rd try] ... where can i get mysql_error codes from? The ones that
 mysql_errno returns.
 

You can get all the OS and MySQL  error codes with:
$ perror `jot 1500` | grep -v 'Unknown error'

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] mysql_errno codes

2003-06-16 Thread Jay Blanchard
[snip]
[3rd try] ... where can i get mysql_error codes from? The ones that
mysql_errno returns.
[/snip]

If MySQL returns an error code (let's use 80 as an example) go to your
shell and type;

perror 80

You will get back a response...

Error code  80:  Accessing a corrupted shared library

If you want to do this via PHP there is a fine example at

http://us3.php.net/manual/en/function.mysql-errno.php


HTH!

Jay

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] mysql_errno codes

2003-06-16 Thread Jeff Harris
On Jun 16, 2003, Thomas Hochstetter claimed that:

|Hi.
|
|[3rd try] ... where can i get mysql_error codes from? The ones that
|mysql_errno returns.
|
|Thanks
|Thomas
|

All mysqld error messages are located into the file
$MYSQL_ROOT_DIR/$LANGUAGE/errmsg.txt (or thereabouts) and listed in
numerical order from 999 to 1175. You can change the output language as
well, issuing the '-L spanish' option for example. See the manual for more
details.

try a $ locate errmsg.txt

Or, if you need them at runtime, try
http://www.php.net/manual/en/function.mysql-error.php

-- 
Registered Linux user #304026.
lynx -source http://jharris.rallycentral.us/jharris.asc | gpg --import
Key fingerprint = 52FC 20BD 025A 8C13 5FC6  68C6 9CF9 46C2 B089 0FED
Responses to this message should conform to RFC 1855.





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Re: [PHP] mysql_errno codes

2003-06-16 Thread David Nicholson
Hello,


This is a reply to an e-mail that you wrote on Mon, 16 Jun 2003 at 17:53,
lines prefixed by '' were originally written by you.
 Hi.
 [3rd try] ... where can i get mysql_error codes from? The ones that
 mysql_errno returns.

In the comments section of http://uk2.php.net/mysql_errno it says:
All mysqld error messages are located into the file
/usr/local/share/mysql/english/errmsg.txt and listed in numerical order
from 999 to 1175. You can change the output language as well, issuing the
'-L spanish' option for example. See the manual for more details.

All the best,

David

--
phpmachine :: The quick and easy to use service providing you with
professionally developed PHP scripts :: http://www.phpmachine.com/

  Professional Web Development by David Nicholson
http://www.djnicholson.com/

QuizSender.com - How well do your friends actually know you?
 http://www.quizsender.com/
(developed entirley in PHP)

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



RE: [PHP] mysql_errno codes

2003-06-16 Thread Thomas Hochstetter
Thanks guys ... always a pleasure.


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php