PHP mysql select date from

[Daffy_Duck]

Hi if I have something like..

$result = mysql_query("SELECT * FROM booked WHERE Date='2007-04-07'")

which just list items for that one day, how would I list everything from a date to a date in the future.

ie like 2007-04-07 to 2008-04-07

[Piranha]

I'm just guessing, but I think that BETWEEN would work. If not it would surely work with => and =< (or is it >= and <=, my brain is not working at the moment).

[Daffy_Duck]

Thanks BETWEEN was what I was looking for

[bradgrafelman]

Don't forget to mark this thread resolved.