Hello folks,

I was playing around with my PHP code that shall report any SQL error. To test
this code I made an error in a SQL query by changing the table name in the
field list to a table that did not exist.

This triggered the following error:

Error message: 'Unknown table 'q' in field list'
Error code: 1109

The error message is correct, but the problem is that the error code (returned
by mysql_errno) is not correct.
A 'perror 1109' say "Illegal error code: 1109".

It seems like the error number returned by mysql_errno is not to be trusted,
or? Any comments?

--
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/

Joern, is the client version of mysql in PHP the same as your client libs
on the server (where you run perror)? PHP is often times compiled with its
own mysql libs and you have to specifically tell PHP to build with the
system mysql libs if you want to.

Just a thought.


Atle

On Sun, 25 Feb 2007, Jørn Dahl-Stamnes wrote:

> Hello folks,
>
> I was playing around with my PHP code that shall report any SQL error. Totest
> this code I made an error in a SQL query by changing the table name in the
> field list to a table that did not exist.
>
> This triggered the following error:
>
> Error message: 'Unknown table 'q' in field list'
> Error code: 1109
>
> The error message is correct, but the problem is that the error code (returned
> by mysql_errno) is not correct.
> A 'perror 1109' say "Illegal error code: 1109".
>
> It seems like the error number returned by mysql_errno is not to be trusted,
> or? Any comments?
>
> --
> Jørn Dahl-Stamnes
> homepage: http://www.dahl-stamnes.net/dahls/
>
>