Display New Entries Based On Month & Unixstamp

[Yokhannan]

Hello.

I have a mysql database with a users table. Within the users table is a datestamp in unix timeformat. (php: date("U"))

I need to know the SQL statment to acquire all of the new members for each month.

I am in need of creating a new php page that lists all the users for each month, broken down into a month-by-month basis.

Thanks.

[r937]

if the column is called dateadded,

select year(from_unixtime(dateadded))  as theyear
     , month(from_unixtime(dateadded)) as themonth
     , count(*)                        as newusers
  from users     
group
    by year(from_unixtime(dateadded))  
     , month(from_unixtime(dateadded))
order 
    by theyear desc
     , themonth desc

[Yokhannan]

wow, amazing!

Thanks!!! I'm 100% positive I'd have never figured that out so easily.

I knew I could do it via php and a bunch of nasty sqls... but I was really hoping someone out here would know how to save me the work!!

So, thanks!