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/10/02 2:23 AM, Henry ([EMAIL PROTECTED]) 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
> 
> Henry
> 
> 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




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
>
>Henry
>
>
>
>  
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php