I have a search form that needs to populate a mysql select query, the html form will be:
Cuisine (Multiple select)
Name (Matched LIKE %string%)
Zip (Matched LIKE %string%)
Delivery ( equals 1 or 0)
Area of town: (Multiple select)
These need to post to the php script and dynamically create the select query.
SELECT * FROM restaurants WHERE cuisine in () AND name LIKE '%%' AND zip LIKE '%%' AND delivery in() AND areaoftown in () ORDER BY name ASC
I realize this project is VERY small, its late and dont want to fool with it.