>Please also note hat UPDATE returns the number of records updated. If your >UPDATE returns 0, you know that the record does not exist, and you might >want to INSERT instead.
There is one situation where the number of records updated will return 0, yet the row exists. If you update the record with the exact same information, mySQL will return a count of 0 rows updated. Yet the row exists. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]