If it were me I would tackle this in two parts. First create a SQL statement that returns the data you want, you say you can do this so the first part is already finished. Then stuff the data into an array and when you go to display the data to the user, that is when you sort it into the chosen sort order. It is not that hard to sort an array and you might be able to find a class already written to do this on the PHP classes web site. You might even go so far as to display the info in a table that allows the user to click on a column heading and re-sort the data on-the-fly without a round trip to the server. This might add a nice touch to your UI without too much effort. Jim -------Original Message------- From: drparker Date: Thursday, March 06, 2003 14:23:29 To: php-db@lists.php.net Subject: Re: retrieve last n records I need the last n records when, say user_id = 3. So it returns all rows where user_id = 3, then, on top of that I need only the n most recently entered records. The problem with the sorting mechanism I have existing is essentially that those last n rows need to be sorted ASC or DESC by every field. So basically, I need to be able to retrieve those last n rows where user_id = whatever, then be able to sort those last 3 rows ASC or DESC by any field. Jim Hunter wrote: > > > 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: php-db@lists.php.net > > Subject: 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 .
