Drop Down List help

[louisstephens]

Ok. I could really use some help on this.

 

I have a database populated with data {firstname, lastname, street, city, state}, and I have a drop down list wich lists the states in the database. SO when you pick the state, it shows the entries from that state in a table. However, I really need my second drop down (which is last name) to populate the same table (using a query)  to arrange them by the last name I choose. I really do not know how to achieve this. I have it written out on paper, what I need them to do, but I dont really know how to achieve this through php.

[GingerRobot]

If you're looking to do this without having the page re-load, you'll need to look into AJAX. There's an FAQ about this very thing here There's two posts - the first showing how do it without a database, the second with.

 

If you don't care about the page reload, you just need to have the form submit to itself - you can then grab the information for the second drop-down and fill it in.