From: "Tyler Longren" <[EMAIL PROTECTED]>
> I'm running an UPDATE query on my table. After executing the query, I
check
> mysql_error() to see if there's any errors:
> if (mysql_error() == "") {
> // success
> }
> else {
> // failure
> }
>
> mysql_error() is always empty even if the query didn't succeed. So it
> always thinks it succeeds. I remember having this problem once quite a
> while ago. I remember somebody telling me that it had something to do
with
> UPDATE. Is there a better way to check for errors?
Please define "didn't succeed"... There is a difference between the query
"generated an error" which is caught with mysql_error() and the query "did
not affect any rows" which is caught by mysql_affected_rows().
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php