It's a MySQL mystery and a PHP Pickle

[Mce]

Hello,

I have a really strange situation and hopefully I can describe it effectively. What is going on is that mysql_query() is returning bool(false) even though the insert succeeds!!! This is evidenced by going into the database and looking for the new record and actually finding it. mysql_error() returns "Duplicate entry on key blah with blah data". I have made sure that there are no matching keys prior to running the insert and it still gives this problem (and at that time inserts the new record). But wait it gets better! If I cut and paste the insert statement into MySQL's client app it works without any errors or problems! I have run and extended check on the table with myisamchk and the table and it's indices all check out good. Any ideas? 😕 :queasy: 😕

[Frederick]

Paste Code

[Mce]

Thank you for actually reading my post before saying "Paste Code". If you had actually read it you would have realized that it was not actually a code issue per se. But seemingly a problem with either PHP or MySQL themselves. One would think that was obvious when I had said that PHP's mysql_query() is making a successful query submission, which was verifiable by the correct information being added to the database, and yet it was returning FALSE. More or less I was looking to see if anyone has had a similar problem and if they knew of any config changes that may have helped. Regardless as I was unable to find a way to get mysql_query() to return TRUE when it was actually successfully executing the query I just decided not to check for failure in that one instance and everything works as expected. I just didn't want to have to resort to that.

Maybe next time you see a post without code in it, you might actually READ it before requsting code to be pasted. You might just find it wasn't a code question.