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