i figured it out, here's what i did if this is useful to anyone else

SELECT DATE_FORMAT(FROM_UNIXTIME(sup_date),"%m-%d-%Y") as sdate, COUNT(id) as scount FROM users WHERE sup_date > "1199145600" AND sup_date < "1202774400" GROUP BY sdate

but if anyone want to give me pointers on how I can change this query to automatically set 30 days from today - that would be super :)

__________________
one outstanding employee does more and costs less than two adequate performers.