Well - what is considered the last of the list? Is it a number? are they names?
Either way you have a field you are ordering by ...
SELECT * FROM table ORDER BY lastname DESC LIMIT 10;
that'll do the trick. FYI you can sort numbers, dates, and chars - this is from
the hip and you might be able to do others ...
--Joe
On Mon, Apr 16, 2001 at 11:53:12PM -0700, Randy Johnson wrote:
> How do I get the last 10 rows in a table?
>
> thanks
>
> randy
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
/* Joe Stump
* Sr. PHP Developer
* http://www.Care2.com http://www.joestump.net http://gtk.php-coder.net
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
