using mktime() help - how many users joined today

[willl]

Hi there,

I am trying to create somecode that will me how users have signed up today. The forum uses the unix timestamp when a new user joins. I have this code so far:

$today = mktime(0,0,0,date("m"),date("d"),date("Y"));

$today = date('dS M Y', $today);  

$query = "SELECT joindate FROM table WHERE joindate = '$today'";
$result = mysql_query($query, $conn);
$todayusercount = mysql_num_rows($result);

echo "<h1>$todayusercount of which have joined today!!</h1>";

However it is not working because it is looking for that particular timestamp and not a timestamp that falls within today's date.

Can anybody give a suggestion?

thanks, Will

[LordRogaine]

I had the same problem. What you want to do is get rid of the minutes and seconds of the day by using...

$today = substr("$today", 0,-9);

Then in your select statement write "SELECT joindate FROM table WHERE joindate LIKE '$today%' ";

[willl]

sound. thanks very much.