retrieve last n records
| From: | drparker | Date: | Thu, 06 Mar 2003 21:42:24 +0000 |
| Subject: | retrieve last n records | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-138535@lists.php.net to get a copy of this message | ||
I need to retrieve the last n records of a table, n will probably be 2
or 3. I know that I can accomplish this by: select * from table order
by field DESC Limit n, but i would prefer not to do this way because it
interferes with my sorting mechanism on the main page. Is there any
other way to do it?