My 2nd question...
I have a form with 3 boxes.. boxes 1 & 2 are select lists from queries of a column in a mysql db table. The page itself begins with a display of the whole table and then using the 3 boxes I want the users to be able to 'drill down' filtering the table as they go..
What I want to do is...
User selects option in box
Page refreshes, Box 2 is populated depending on the results & the table is filtered
User selects option from box 2
Page Refreshes and box 3 is populated depending on the results of box 1 AND 2 - likewise the table
Box 3 is a final choice narrowing it down to only one row of the table
Hopefully you get the idea but here is the example - Its a table of spaceship data for eve-online.
Certain ships can only be flown by people of a specific race (i.e. box1) (Columname=ShipRace)
Then depending on the race - certain classes of ship are available like battleships, cruisers, frigates etc (Box2) ColumName=ShipClass
Box3 would then display a list of only ships that meet box1 and box2 criteria, where user can filter to the one ship (columnName=ShipName)
Now I will be OK with the majority of this I think - apart from the reloading on select part. How is this achieved? It will need to perform a 2 queries (to load the options for the next box and one to filter the main table), then reload the page and the next box dependent on the results.
I have a nasty feeling there may be some JS involved?
Many Thanks
