Affected rows: 0 on UPDATE statement

acidbox

I am running an update statement in MySQL, and for some reason, no matter what I do, the thing always tells me that the affected rows are zero. I have made sure that my where statement is correct, and have even run a select statement with the exact same where statement to make sure that it returns a row. It does.

Is there anything that I could be missing for the UPDATE statement to update zero rows?

Here is the SQL statement I am trying to run

UPDATE themes SET theme_name = 'red', theme_id = 234234, theme_flag = 'on' WHERE user_id = 'DX-02080003'

that user_id IS valid and works with select statements.

mrmufin

Yes, please post the query. mysql_affected_rows() will return -1 on a 'bad' query, a '0' if no rows were affected by the query, or an integer representing the number of rows affected by the query, which is what I suspect you're looking for...

thanks

acidbox

i posted the SQL in the above post.

The problem is that I am changing the information that is currently stored in the row, however, it is not changing.

I will report back with the affected_rows, but there isn't any errors I am sure because I tested it with phpMyAdmin and it didn't give me any errors.

brb.

acidbox

mysql_affected_rows() reports 0

hope that helps. this is so weird.

mrmufin

The query looks fine. Now, if you could, please show the query within the context of your application. Since this much looks OK, let's see what surrounds it, and determine why the affected_rows() function isn't behaving as you expect it should...

Thanks

acidbox

mysql_affect_rows is performing fine. The database is NOT updating like i want it to, even though I am trying to update it.

Ill get back to you in a sec.

GSHelpBoy

Add a print(mysql_error()) so you can see what's going wrong.

MrAlaska

Originally posted by acidbox
i posted the SQL in the above post.

The problem is that I am changing the information that is currently stored in the row, however, it is not changing.

I will report back with the affected_rows, but there isn't any errors I am sure because I tested it with phpMyAdmin and it didn't give me any errors.

brb.

I am not familiar with phpMyAdmin, but I am assuming it has decent built in error reporting.

You say you ran THIS query on phpMyAdmin and reported no errors and no rows affected? The problem then, has to be in your WHERE clause. Copy the ID out of the where clause and run a select * using the exact ID and see if anything gets returned.

EDIT: OOPS, you already did that! I dunno, that is strange...

Are you able to update ANYTHING? Is it that row only? Is it the whole table? The database? All your databases? Are all your base belong to us?