Re: [PHP] checking if a MySQL update worked

2002-09-30 Thread Justin French
If result is true, I take this to mean that the query could be executed. And I take MySQL affected rows to mean that N rows were affected AND the result was true: I haven't dug right down to make sure this method works for every problem, but so far, no problems found. Justin French on 01/1

Re: [PHP] checking if a MySQL update worked

2002-09-30 Thread Marek Kilimajer
mysql_error() will contain error text if "it didn't work" Henry wrote: >Hi All, > >mysql_affected_rows() returns zero if you update without changing the data >in a database record. How do you tell the difference betwix "it worked but >nothing changed" as opposed to "it didn't work"? > >TIA > >He

[PHP] checking if a MySQL update worked

2002-09-30 Thread Henry
Hi All, mysql_affected_rows() returns zero if you update without changing the data in a database record. How do you tell the difference betwix "it worked but nothing changed" as opposed to "it didn't work"? TIA Henry -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: h