selecting date correctly

[jeff5656]

I am trying to select records with today's date but am getting zero hits:

$currdate= date("y-m-d");
$query = "select id from table1 where some_date = '$currdate'

 

the problem is that the date is stored as a datetime so there is a time after it.

How do I modify the above query to select for today's date and ignore the time part?

 

 

[scootstah]

You use MySQL's functions.

 

$query = "select id from table1 where some_date = NOW()"

[PFMaBiSmAd]

To reference just the date part of your datetime value - http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date