@sameer_net_inJul 26.2006 — #Is there an auto incrementing ID column? If so:[CODE]SELECT * FROM [I]tablename[/I] ORDER BY id DESC LIMIT 10[/CODE][/QUOTE] if you want latest 10 updated rows
add a some field say 'ts_fieldname' of type timestamp and set its attributes 'ON UPDATE CURRENT_TIMESTAMP' and default CURRENT_TIMESTAMP
now u can get latest 10 updated rows as [CODE]SELECT * FROM [I]tablename[/I] ORDER BY ts_fieldname DESC LIMIT 10[/CODE]
@bokehJul 26.2006 — #not u can get latest 10 updated rows[/QUOTE]The question said inserted not updated. Obviously though your method would be good in the case of updated rows.