Welcome to WebmasterWorld Guest from 126.96.36.199
Forum Moderators: open
I have a timestamp in my database called "created" in the format of yyyy-mm-dd hh:mm:ss.
Right now if I group by created, its grouping my users all the way down to the second. Is it possible to make my grouping by day?
Also, how might I make sure that my user counts are sorted by the creation date, where the most recent day is listed first?
$query=mysql_query("SELECT COUNT(users) FROM database GROUP BY created");