Welcome to WebmasterWorld Guest from 23.20.82.60

Forum Moderators: open

Message Too Old, No Replies

mysql selecting latest records

     
7:58 pm on Sep 7, 2005 (gmt 0)

New User

10+ Year Member

joined:Apr 11, 2005
posts:20
votes: 0


Hello,

I have a mysql database with users that fall under one of 4 categories. I need to run a query to :

select 4 latest users, 1 from each category.

How can i format my select statement to acomplish this?

the fields to use are:
username, category, signupdate

I'd appreciate any help. Thanks