Got a database of company reports, one of the required means of searching it will be by "date of report". The date information is carried in a single field in the database, and they are stored like this for each record:
27th January 2000
31st March 2000
13th May 2000
...and so on.
To avoid the end-user having to type anything in, my line of thinking was to have three drop down menus in the search form. One for the date, one for the month, one for the year. The trouble is, I cannot grasp how to get all three separate variables to carry across to the search as a continuous search string (in this instance: 27th+January+2000). What I currently get is the following:
search_date.php3?date=1st&date=January&date=2000
...this returns no results obviously. I am guessing my problem lies in the way I've coded the HTML for the form, but I'm not sure how to get around it. HELP!
