in reply to MySQL Query

You don't really provide enough information to allow for a complete answer. However, given that you have an ID, you probably want to check out the DESC keyword. Something like:

SELECT whatever FROM table ORDER BY id DESC;

The results will be sorted in descending (or reverse) order. See http://www.mysql.com/doc/S/o/Sorting_rows.html for more information.

If things get any worse, I'll have to ask you to stop helping me.

Replies are listed 'Best First'.
Re: Re: MySQL Query
by ask (Pilgrim) on Nov 22, 2001 at 07:33 UTC
    ... and adding
    LIMIT 5
    to the end will with some database servers just give you the first five records of the result set.

     - ask

    -- 
    ask bjoern hansen, http://ask.netcetera.dk/   !try; do();