Would someone please try & modify this query in a way that it shows the count for how many users have registered for the current day ?
So like right now it should display a count of 2 and then come midnight it would show 0 and then incrementally go up for every user that registers for the day and then the following day at midnight reset to show 0 and start the count all over again.
All times in the registered table are in a unix format (1288796722).
$request = mysql_query("SELECT COUNT(`registered`) AS total FROM `ucard`");
list($latestmember3) = mysql_fetch_row($request);
Ps; I could be wrong but did I over complicate the already provided code and if so how could it be cleaned up ?