Skip navigation links

MySQL Forums :: PHP :: Update failed with NO mysql_error


Advanced Search

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 Jean-Pierre Falet 07/26/2009 09:53AM
Re: Update failed with NO mysql_error Jean-Pierre Falet 07/26/2009 11:00AM
Re: Update failed with NO mysql_error Scotty Miller 07/28/2009 03:16AM


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.