records from todays date

[adzie]

Hello folks I want to be able to select records only with todays date.  The date field is a datetime field.

 

$number = mysql_num_rows(mysql_query("SELECT * FROM records WHERE user_id = '$users[opened]' AND active = '1' and date = 'today'"));

[jonsjava]

$number = mysql_num_rows(mysql_query("SELECT * FROM records WHERE user_id = '$users[opened]' AND active = '1' and date = CURRENT_DATE;"));

[PFMaBiSmAd]

If the date field is a datetime (with the time as part of the data), you would need to use the mysql DATE() function to get just the date part for the comparison -

 

DATE(date) = CURDATE()