DB search tool?

[Roze]

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.

[Trance-formation]

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?

[SEO Jeff]

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.

[Roze]

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.

[Trance-formation]

he he , well into the early hours of the morning... you'll do it;)