MySQL Forums
Forum List  »  PHP

Update failed with NO mysql_error
Posted by: Jean-Pierre Falet
Date: July 26, 2009 09:53AM

Hello,

I am in huge confusion. I have a db set with the contents of each page. When the user changes the content through a form, it passes through a process page which takes the new content (from the textareas), cleans it up, preps it with mysql_real_escape_string, and then updates the db content which relates to the specific page. Now, weirdly, when nothing is changed in the textareas and the db is updated, the update somewhat fails (mysql_affected_rows returns 0). If i check for a mysql_error, there is none. Why?

Thank you.

EDIT: Wait a minute....does that signify that when you do an update when you didn't change the content, it returns that 0 rows were affected?



Edited 1 time(s). Last edit at 07/26/2009 10:48AM by Jean-Pierre Falet.

Options: ReplyQuote


Subject
Written By
Posted
Update failed with NO mysql_error
July 26, 2009 09:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.