Re: [PHP] retrieve last n records

2003-03-06 Thread drparker
t;[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, March 06, 2003 2:42 PM > Subject: [PHP] 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

Re: [PHP] retrieve last n records

2003-03-06 Thread Kevin Stone
- Original Message - From: "drparker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 2:42 PM Subject: [PHP] 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 ca

[PHP] retrieve last n records

2003-03-06 Thread drparker
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