PHP MySQL recordset advanced results page problems! please help!!!

[dstantdog3]

Rawr! I'm a newbie here. Trying to learn to do this myself through the use of Adobe Docs and online tutorials. However - I've ran into a problem that's really holding me back!

 

I'm creating a simple .php MySQL dreamweaver cs3 search, results and details page.  My MySQL database is setup like this:

 

TYPE  |  SKU#  | MAKE |  etc.

---------------------------------

Forklift| 020205|hyster|5,000lb

etc.

 

What I'm trying to do is have a multipart drop down or list search feature so people can search via their criteria.  They can either search by "type" with a list of types.  Or they can search by "make" with a list of makes.  Or they can search by multiple to narrow results...ie search by Type, Make and Capacity to come up with 1 or 2 records.

 

I've got the first search function of "TYPE" to work great.  Anytime I try to add another search list/menu drop down box nothing comes up.  I'm pretty sure this has little to do with the search.php page but it's on the results.php page.  I just can't figure out what I need to do here!

 

Do I need to create multiple Recordsets for each column header?  Or do I create 1 recordset with an advanced SQL statement? If so...how should that SQL statement read?  I've tried so many different ways....SELECT * FROM databasename WHERE columname, etc.

 

If someone can help me out on this I'd be so very appreciative.  I've probably wasted 20hrs in the past 4 days working on this and not getting anywhere.

 

Thanks!!!!

[peddel]

first of all, this should go to the MySQL subforum

secondly, plz post ur code, else people wont be able to check where it went wrong