[SOLVED] Small date question

[waynew]

I have a datetime column in one of my tables, which means that every looks a bit like:

 

2008-11-20 11:58:00

 

Now, I want to show every record for today. So I would get todays date like so:

 

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

 

Now, how would I select all records that relate to todays date? I'm pretty sure that you can't do something like:

 

WHERE dateOrder = '$current_date'

 

As the datetime column includes the hour, and not just the date.

 

Anyone wishing to shed the light?

[Mchl]

WHERE DATE(dateOrder) = CURDATE()

[waynew]

Thanks! How would I go about getting tomorrows date? Or, a user-selected date?

[Mchl]

that's usually task for PHPs strtotime

 

$date = date("Y-m-d",strtotime("tomorrow"));

$query = "SELECT ... WHERE DATE(dateOrder) = $date";

[waynew]

Ah! Now I see...! Thanks a mill.