Hi,

My database has a field called ID which is an auto increment integer. This starts at 1 and when a new record is added the value goes up to 2 etc etc.......

anyways the provblem is when im displaying this information through my PHP code. I want the newest entry to be displayed at the top of the records (like a news story does)

I have used the ORDER BY sql thingy to order the field in the normal manner but this gives the opposite effect that i desire.

Is there a SQL order that would flip this to display the newest entry at the top?

thanks
ASH:D

__________________
My new web design domain
www.askmultimedia.co.uk

There are two sort options, ORDER BY `field` ASC and ORDER BY `field` DESC, I assume you probably want the latter.

HTH!

Regards,
Rich

--
[http://www.smilingsouls.net]
[http://pear.php.net/Mail_IMAP] A PHP/C-Client/PEAR solution for webmail

that works super duper:D;):)

Ash
www.askmultimedia.co.uk