hi in the php manual, regarding 'mysql_affected_rows()' it says: When using UPDATE, MySQL will not update columns where the new value is the same as the old value. This creates the possiblity that mysql_affected_rows() may not actually equal the number of rows matched, only the number of rows that were literally affected by the query.
i'm running a query that will attempt to update rows in a table. it runs an update statement for each id (loop), so mysql gets sent 10 updates. now, when i add the affected row nums, i get 10, even though i haven't changed any of the values. but if i paste any of the queries into phpmyadmin to run, it gives 'Affected rows: 0'. so how come the difference? abs ________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]