--- Abs <[EMAIL PROTECTED]> wrote: > 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?
i cancelled the line that executes the query and instead pasted it in PMA, it chaged a row. but i don't see any difference in the data. are there any issues like assigning an int col with the data in single quotes? as in, assigning id = '5' instead of just id = 5 ? i'm using varchars, chars, ints, etc. no blobs or texts. still dunno why the diff. 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]
