I am having a hell of a time right now, I've been troubleshooting for like 24 hours straight.

Syntax is 100% correct. I have a script, I have a mysql INSERT statement that I execute, mysql_query() returns true on the insert, but _affected_rows() return nothing.

However, my Autoindex for ID, is incrementing in my database, like it is trying to add something, or it is, and then it is being deleted. I've checked MySQL logs but they tell me nothing.

Any thoughts? It does this on both my wamp server and unix

Possibly related:

http://bugs.mysql.com/bug.php?id=37560

What version mysql (and php) are you running, by the way?

php 5.2.8
mysql 5.1.30

What I failed to mention before, was this all stemmed from an earlier issue that was very similar. Further in the script, I had a different insert statement, above it I had a delete statement. When it was executed it would insert 2 rows, one of the columns had a random string generated and each column was different, which made me think the PHP was executed twice. When I removed the delete statement, it would insert 1 row but leave out half of the columns data, and the autoindex would increment by 2. When I came up with a solution for that, this latest problem occurred.

In my database class, I saved all the queries to an array and at the end of the script I output that ****. And to my surprise everything was correct, if I copied each query individually they would work directly inserted into mysql. Only 11 queries were being executed total for the entire script.

affected_rows returns nothing? It should always return SOMETHING, be it -1 for failed query, 0-infinity for rows affected.

I think by 'nothing' he means 0 not null.

as a matter of fact, no it returns nothing

Oh. What.

I dunno I'm about to burn this whole thing

You have a proper link identifier set for it, right?

I did, but actually I just saw it was commented out

I finally found the problem, you ready for this

<img id="banner" src="" width="120" height="113" />

hahahahahaha

It's times like that I really, really, really hate programming.

Yeah, that's so "PHP".

Next time post sauce!

Try the query directly in MySQL console tool or PHPmyadmin or something to make sure the query itself isn't the problem.

MZZT didn't read the thread!

Not only did he try that, he's found and fixed the problem.

Oh.

Haha src="", hahahaha.

LAWL.

I'm thoroughly confused as to what an img tag with a blank src tag has anything to do with an INSERT statement.

Take avatars on the typical vBulletin forum, Wolfy. Since the avatars are typically stored in the MySQL DB, a query is ran to obtain a user's avatar from the DB. There is a script such as "avatar.php" which sole purpose is to do this. The avatar.php would be called from the img tag where the avatar would go, and the avatar.php would return the avatar.