Sorting a Dynamic Drop box

[joe1182]

I have a drop box that is being populated by my database but, I would like to sort alphabetically. Is there anyway to do this? Also is there a way when an item in the drop box is selected that other fields in that database table will automatically appear in a seperate text box that I designate? Like I want "cutomer name" to be the option to choose from in the drop box. When selected I want "customer address" and "customer phone" to appear in their own seperate text boxes. Any help would be greatly appreciated.

[joe1182]

Can anyone help me out?

[coopster]

I would sort the data as I retrieve it from the database using an ORDER BY clause.

SELECT lastname, firstname FROM table ORDER BY lastname;

[joe1182]

thanks coopster! Any help on the second part of my question?

[dreamcatcher]

Hi joe1182,

I believe what you are looking for here is javascript. If you want the options to appear for instance after a page refresh, then yes, you can do this with PHP. But if you mean having the boxes change automatically client side, this is a javascript thing.

If it is javascript you are after, try the javascript forum.

dc :)

[joe1182]

thanks