Dynamically-Alphabetically Drop-Down Menu from database values

shalinv

Hello everyone:
first of all thank you very much for taking time and reading my problem. my question is very simple if you are expert with PHP or JavaScript.

I am looking for Dynamically Populated Drop Down menu from database that is automatically arranged Alphabetically. to put it in simple word..

let say,
I have 3 Categories for car.
1.Honda
2.Toyota
3. Nissan

now if i select Honda, next drop down menu should be populated with..
1.Civic
2.Accord
3.CR-V

now if i select Accord next drop down menu should be populated with...
1. 2W D
2. 4W D

[ similar simulation at : http://www.javascriptkit.com/script/script2/triplecombo.shtml but its not database driven ]

but only thing is all these values are stored in database. ( eg. access or excel CSV file ) and it not in alphabetical order, but when it comes to displaying it, it should be re arranged in alphabetic order automatically.

do you think it is possible?? either PHP or JavaScript code will do for me. Thanks in advance.
🙂

dalecosp

Personally, I'd run the db in MySQL or PostGre and use "order by" ...

But, I guess you could fetch an array and then use [man]sort/man or [man]usort/man or something ....

HTH,

shalinv

I was trying to follow your comands but its hard to fit in. does any one has complete script that will do such thing?

LordShryku

Don't come one here expecting people to just write code for you. That's not how it works. Most of us make our living writing code for other people.

Now your problem, if you don't have a SQL database, and refuse to use a SQL database, look at building an array and using one of the array sorts

shalinv

i think i posted my question under general help. i understand why would you spend time for me? but question was directed to those people who knows where to find such scirpts on net. as i know there are scprits available but its only matter of finding them. if you are smart with one thing doesnt mean that you are smart enough with everything.... your knowladge grows if you share with others!! otherwise it goes away day by day. i just need help of people who has been programming and know where to find answer to my question. Thanks

LordShryku

Okay, so you just want a pre made script. I'll send you to the same place I would go if I wanted to search the net for a pre-made script. Consider this "me sharing my knowledge".

Google

shalinv

since you can not explain me how to connect and use comands to re arrange array values i would take that from you!!
Thanks 4 ur help!!

andymoo

if i get understand your question (which i might not as i can't remember sleeping for a couple of nights now) there are javascript tutorials giving you the info you need to propagate the entries and values of a select form field depending on the value of another select field on the page.

this combined with mysql might be a viable answer or i might just need to get some zedzzzzzzzzzzzz