selecting a range of dates

[Anon]

How do i do a select statement, and specify a range of dates.(ie, where date lies between date_1 and date_2). I intend the user to input the two dates in a html form. I am using a mysql data base.
please help with the necessary PHP and HTML scripts combination to do the search.

kind regards

[bastien]

select * from table where myDate between $StartDate and $EndDate

hth

bastien