Whats the best way to do this.

10K rows from mysql to fill about 10 select menus!

[smagdy]

Hello,

I read about 10K rows from mysql (just char field) and i need to divide them on about 10 select menus..

and they will be hidden and only one will be displayed upon user choice of other select menu.

so someone has helped me with the hide/show in javascript section, but i dono how to put them in select menu in a fast way for loading.

is it possible to built 10 different select menu in for loop where am reading from mysql and i check my condition to fill the corresponding select menu?

i cant c its possible unless by having new 10s select menu each time it loops...

the thing is that i dont wana read the 10K rows each time to build each select menu..

any clue?

Thanks a lot in advance

[bennymack]

This sounds like a great oppurtunity to use AJAX.

[smagdy]

and what is AJAX?

Please i really need help with it..

[smagdy]

hmm i searched for "AJAX" and it seems its something like "xmlhttprequest" which i used it before.. but can u lead me to somethin to help me with the select menu thing?

thanks

[bennymack]

This link on wikipedia should be enough to get you going:
[en.wikipedia.org...]

Its got thorough explanations and examples in several languages.

Beyond that, I cant help you out too much. Just try to find a way to fill in the selects with the information they need based on user actions.

[smagdy]

Thanks a lot

it finally worked.. so now am creating the select menu i want on the fly upon user choice of other fixed select menu...

Thanks for the keyword "ajax" :)

anyone got problem using it.. just ask me cuz i got some experience in it last night cuz it took time till i got it work..

Thanks