Get actual rows affected after UPDATE

[php_techy]

Hi,
I am using the following mysql query statement:

mysql_query("UPDATE inventory SET username='$username' WHERE username='$target->username' ORDER BY RAND() LIMIT 15");

now I want to also display to the user which rows were affected by the above query and list all those rows in an echo or something.

I know i can use mysql_affected_rows() to find HOW MANY rows were affected but can you make a script that will list the rows that were affected? or is it not possible?

Regards

[djr33]

After looking a bit I can't seem to find anything. Depending on your needs you could obviously make a query that would find all rows of some type and just use that with he same criteria from your other query. A full solution would probably need to be part of the mysql architecture and not something added in php.

[akitodito]

Can you let us know how you get on with this as I use tiny MCE on several applications