no incremental id or timestamp. How can I get first 10 or last 10 records

[Atif Ghaffar]

Hi guys.

Here is the thing, 
Our customer is asking for a feature (maybe others will ask for it too).
When someone opens the contacts window, the last n records are
displayed.

so with an incremental id or a time stamp missing, how can one do it?
I know the auto_incremental is mysql only stuff, but please think about
adding a lastModifed field which may contain simply the unixtime. This
should work for ldap too.

so getting last 10 entries would be simply 'order by lastModifed DESC'
and 'limit 10'

thanks.


-- 
Atif Ghaffar
Internet Development Manager
4unet AG/SA/Ltd.
-------------------------.
        +41 21 351 53 60 ¦ voice
        +41 78 787 51 45 ¦ mobile
        +41 86 0796598972¦ fax
    http://www.4unet.net ¦ www
http://atif.developer.ch ¦ homepage
  atif.ghaffar@4unet.net ¦ email