Welcome to WebmasterWorld Guest from 54.158.54.179

Forum Moderators: open

Message Too Old, No Replies

mysql selecting latest records

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

10+ Year Member



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

 

Featured Threads

Hot Threads This Week

Hot Threads This Month