Re: retrieve last n records

OK, I would like to do it with the method you suggested. However, I'm having a few problems. Firstly, I can't seem to figure out how to sort rows returned from mysql_fetch_array. sort() or any other array function won't work because each row is an array, and I need to sort by the column. Secondly, which PHP classes website are you referring to? I don't even know how I would use a PHP class in conjunction with it if I did find the site. Thirdly, I do need to re-sort the data on-the-fly. Would this essentially be accomplished if I were just sorting the table data via PHP functions? Thanks for your help. Jim Hunter wrote:

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: [PHP-DB] 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: [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

.