Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

mysql selecting latest records



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

10+ Year Member


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


Featured Threads

Hot Threads This Week

Hot Threads This Month