I currently run your typical city guide web page
and for this entire post i am going to use my artsandculture page
with in this page i have sub pages of museums,wine,galleries
when a user clicks on museums there is a list of all the museums in html format and the page is a mile long
what i would like to do is delete all the html
and give the user a form with 2 fields and a submit button
the first option t he user would have to choose is location--i.e. downtown,eastside,westside--location of the museums they are looking for
the 2nd field would be called catagory- here they would choose wht type of museum i.e. science,childrens,historical,
both fields have to be in a pull down menu
once the hit submit it gets info from t he database and shows the following results
name of museum
i need a search thin on 8 different pages so would i use one database and 8 tables?
or put everything on the same table and make sure non of the variables are the same?