Hi, I'm looking for a functional program that will help me have a database search form on my site. I'm having trouble coding this... I use PHP with MySQL I want it to be able to take fields in the DB and populate drop down boxes with the data available, so users can simply choose a few options and hit Go... I was looking at DaDaBik but they dont have a self-populating option, and I dont want to link multiple tables. Here's what I want to do... Widget Database: Color Size Flavor Red Big Fruity Blue Tiny Meaty Green Medium Spicy And I would like to have a script which will take the fields of my choosing and create drop down menus based on available data. Color: (drop down menu would say Red, Blue, Green) Size: (drop down menu would say Big, Tiny, Medium) Flavor: (drop down menu would say Fruity, Meaty, Spicy) Any one have a solution for me? It's a bit beyond my coding abilities.
So you want vistors to be able to select say, Red Tiny Spicy widgets and have the search script return all such widgets?... I reckon I could code that quite quickly with a few more details on the db structure if you want some help?
Have you taken a look at using MySQL's Full Text engine? It allows you to search through your database. I use dtSearch myself (http://www.dtsearch.com) and I love it. Very powerful, easy to intergrate, etc.
cool, thanks for the leads. I spent all day working on peripheral parts of this search and I think I may actually be able to do it alone...keep you posted.