mistake, sorry. works not either (see last message)
----- Original Message -----
From: "Remco van den Berg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 3:15 PM
Subject: Re: How to select the 10 last items from a table?
> On Wed, Jan 31, 2001 at 08:00:23AM -0600, The Tilghman wrote:
> > Try sorting in DESCending order.
> >
> > SELECT * FROM item ORDER BY id DESC LIMIT 10;
> >
> > -Tilghman
>
> People,
>
> Thanks for all the answers, but the question was:
>
> "How to get the last 10 items in incrementing order."
>
> Please read thread before answering.
>
> -Remco
>
>
> ---------------------------------------------------------------------
> 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
>
---------------------------------------------------------------------
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