I guess I am confused, how does one query effect a query that you have in
an other part of the page? The two queries are not related. The second thing
I am confused on is: Do you want the last n records that were added to the
table or do you want the last n records in a given index?

Jim
-------Original Message-------
 
From: drparker
Date: Thursday, March 06, 2003 13:46:58
To: [EMAIL PROTECTED]
Subject: [PHP-DB] retrieve last n records
 
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?
 
 
 
 
-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
 
. 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to