Hi,
I have a table were all rows have their own ID. How can I select only the
last items out of this table?
This command fixes it but I receive the items in the wrong order that I
would like them...
SELECT * FROM item ORDER BY ID DESC LIMIT 10
brgds
Andreas

Andreas Karlsson
MAGNET- Motorola Applications Global Network
Campus Gräsvik 2
371 75 Karlskrona
Phone: +46-455-379 306
E-mail:[EMAIL PROTECTED]
____________________________________________
Become a MAGNET member - register at:
http://www.motorola.com/developers/wireless/

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to