Re: retrieve last n records

[Doug Parker <drparker@clam.rutgers.edu>]

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:  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