Matching dates in query

[saltious]

Hi all.

i have date stored in a field with the format 2009-03-20 (for example... and notice the dashes).

i would like to be able to pull this date from the table by matching it to todays date.

i have tried

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

but this gives date wit 2009/03/20 so does not match what is in the table.

does anyone know how change the / to - ?

many thanks guys!!!!

[paulnaj]

Not sure if I understand your problem, but ...

$today = date("Y-m-d");
echo $today; // prints 2009-06-16

P.

[saltious]

thanks paul

this works fine.

however, i am running this as the 'where' clause in a query but i never get a result.

strange thing is even if i replace the function for simply '2009-06-16' i still get 0 results. i know for a fact there is an entry in my date field with the value 2009-06-16'.

could it be to do with the formt of the field not matching this date somehow?

any other ideas?

many thanks.

[Bjom]

....WHERE myField = CURDATE();

[saltious]

thanks!! that worked

now for the cherry on top.....

how do i take this and say everything on dates tomorrow? and two days from now etc.

thanks again.

[Bjom]

have a look at the manual? or try a few things like adding or subtracting?

[dagon]

SELECT foo WHERE date(NOW())= date(date_field)

assuming your date field is at a valid datetime\timestamp

[bradgrafelman]

And to test for $x number of days from now:

WHERE date_field = CURDATE() + INTERVAL $x DAY