On 8/3/06, André Hänsel <[EMAIL PROTECTED]> wrote:
Hi Dan, hi Obed,
of course I have no specific username, I want the last 5 downloads of each
distinct username in the table. :)
i was thinking a lot... and i can't find the solution.... but maybe yo
can do somthing like this
select user,download from table where user in (select distinct user
from tabla) order by time desc;
and in your front-end just display 5 for each user xD
i you find the solution please let us know !
good luck
--
http://www.obed.org.mx ---> blog
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]