i need help with php/mysql syntax that will search a mysql dbase using 3 user-provided (from web form) options. All options are contained in drop-down menus.
the mysql database has an auto column which is the primary key allowing for duplicate entries which are neccesary
the table has 2 more columns (date & details) which are not visible through the web form but should appear in the search results
the search results should show ALL houses matching the 3 criteria plus data contained in their other 2 columns in the database
error message when NOT FOUND
help much appreciated here!
a link to the sample form: