mysql_errno() and mysql_error not returning anything

[Debbie-Leigh]

Hi,

When I use the following statement:

$objResult = mysql_query($strQuery, $resConnectionId) or die("mysql_errno = " . mysql_errno() . "<br />mysql_error = " . mysql_error());

and there is definitely an error e.g. duplicate insert, mysql_no and mysql_error return nothing. I need to be able to do things based on the value of mysql_errno.

Could anyone suggest what could cause this?

DebbieLeigh

[Sxooter]

Do you have any other mysql connections open?

[bastien]

is the dulicate insert including the id value of the row or violating a unique index constraint on the row?

Without it, even though data is the same it will be a new insert.

[Sxooter]

You can try echoing the query to the screen and running it by hand to see if you are getting an error for real or not.

[Debbie-Leigh]

I've just found the solution. If I pass the connection id to the functions, it works perfectly. I knew it was something too simple to see. Woods and trees, I suppose.

DebbieLeigh

[Sxooter]

That's why I asked if you had any other mysql connections open. As per the mysql_error() page:

If no link is explicitly passed to the function, the last successful open link will be used to retrieve the error message from the MySQL server.

So, if you've opened up >1 link, the last link opened is the one it runs on.