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