Search via drop down list

[clo8]

Hiya

How would I go about writing code so that a user could search by a drop down list, clicking on the date they want and then the page shows the record with date, availability and price from the database??

xcx

[clo8]

Also would the drop down list be able to call the dates from the fields in the database rather than writing them all out in the code?!

Thanks