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 :)

__________________
"Things you can get access to, you should never memorize." -Albert Einstein
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin