Count records per day
Posted: Fri Jun 06, 2008 4:53 am
A couple of months ago I created a query that would count the number of records per day.
I have a `users` table in which I store a unix timestamp of when they registered.
I wanted to count the number of registration per day so I can graph it.
As i said, i did create a query for this a couple of months ago, but after a hard drive crash, i lost it, and i cant for the life of me remember how i did it.
Any ideas?!
I have a `users` table in which I store a unix timestamp of when they registered.
I wanted to count the number of registration per day so I can graph it.
As i said, i did create a query for this a couple of months ago, but after a hard drive crash, i lost it, and i cant for the life of me remember how i did it.
Any ideas?!