Hi there

I'm not sure if I'm posting this in the correct section...

I need to create three dropdown boxes (box 1:colour, box 2: price, box 3:brand) and when the user presses "GO" they are returned with the correct information, pulled from corresponding fields in my MYSQL database.

For example, colour: silver, price £100-£200, brand:samsung...should return 5 items on the page.

I do not need the dropdown boxes to populate depending on ther previous selection - they are static, so to speak.

I am not sure how to do this and appreciate any help at all, even if it is sending me to a tutorial on how to do this.

Many thanks in advance

Basically you need to build a query up using the dropdown values

how much PHP do you know

Thanks fo your reply.

My page son my website are all built in php to pull from my database. I only know enough php to perform the functions I need, but can learn.

I'm not sure what you mean by "Basically you need to build a query up using the dropdown values"...please can you elaborate?

Or can anyone send me to a tutorial that covers this EXACT issue?

Many thanks

You can read this tutorial:

http://www.plus2net.com/php_tutorial/list-table.php

pumadice

this is not what's required although could be used to make it a nicer function

When you query a db through PHP you pass SQL to the database

If your wanting to drive your query through chosen options of a select dropdown then you have to build the SQL dynamically before finally submitting the query to the db

Its a bit tricky if you don't know PHP

Although i don't help for free on specific projects I can help if you want to learn PHP which will improve your understanding?