Simple PHP Date Comparison

[arunkar]

Hi,

 

I'm very new to PHP. I'm trying count the number of registrations today and display in the web page. Below is the code I'm using but I'm unable to compare:

 

The date is the mysql database is stored as 2008-03-27 21:09:41

 

$today = date("Y-m-d");

$resultCount = mysql_query("SELECT count(*) FROM users WHERE registerDate='$today' ");

 

its returning 0 but there are 2 registrations. So there is a logical error. I'm using the date functions here: http://sg2.php.net/date for reference.

 

Any ideas? ???

 

Thanks in advance. 

[ryeman98]

$today = date("Y-m-d");

$resultCount = mysql_query("SELECT count(*) FROM users WHERE registerDate='$today' ");

 

Try changing it to:

$today = date("Y-m-d");

$resultCount = mysql_query("SELECT count(*) FROM users WHERE registerDate='$today*' ");

[PFMaBiSmAd]

Your field in the database is a DATETIME type. If you want to compare just the date, then your query must reference just the date (the mysql DATE() function will work.) Also, it is not necessary to use any slow php code to form today's date, just use the mysql CURDATE() function -

 

$resultCount = mysql_query("SELECT count(*) FROM users WHERE
DATE(registerDate) = CURDATE()");

[arunkar]

Thanks PFMaBiSmAd  it worked like a jem!

 

Thanks ryeman98, it did not work though...

 

 

cheers