Dropdown Box - PHP, MYSQL

[mj99]

When populating a dropdown box from a mysql field, is it possible to limit the entries to only those related to another field? My fields are year, make, model, style, part, installed_price.

example:

make based on related years
model based on related make
style based on related model
etc.

I will refresh the page with each selection so don't need Javascript.

Is there a SELECT query that will do this?

[deo]

Use a WHERE clause... If your table looks like this....

PARTS TABLE

MAKE MODEL YEAR PART PART_DESCRIPTION

Ford Escort 1995 Breaks two breaks 29.99
Ford Ranger 2000 Breaks bla
Ford Probe 1985 Breaks bla

First you want make your SQL looks like this...
(user selects Ford)

$query  = "SELECT model FROM  parts ";
$query .= "WHERE MAKE = "Ford";

Populate a drop down with the results... for this example should be

Escort
Ranger
Probe

Then he selects Escort...

$query  = "SELECT year FROM  parts ";
$query .= "WHERE MAKE = 'Ford' ";
$query .= "AND MODEL = 'Escort' ";

The "WHERE MAKE" is not absolutely needed but will definitely cut out any chance of selecting the wrong data.

Now give the user a list of years that you have in your database for that make and model and have them choose a part or whatever... if they chose breaks the query would look like this...

$query  = "SELECT part_description FROM  parts ";
$query .= "WHERE MAKE = 'Ford' ";
$query .= "AND MODEL = 'Escort' ";
$query .= "AND YEAR = '1995' ";
$query .= "AND PART = 'breaks' ";

and the query returns "two breaks 29.99" you get the idea

Deo

[bobby_rahman]

Hiya I hace created a dynamic table and have entered a drop down box. I wish to get all the column titles from the table and be able to order the table depending on the selected filter automatically ( in a perfect world with out refreshing)

I can get all the fields into the drop down box on the form but now need to build in the logic of sorting tha table depending on the choice.

Im sure it will contain the logic of
SELECT * from <table name>
......
ORDER BY $filter

//the $filter = selected from the drop down

I need further suggestions on
1. Where I can find a decent tutorial on dynamic drop down boxes(if they called that in the first place)
OR/AND
2. Code snippets that may help me to understand the logic

Any help wld be great Thanx 🙂