Database query on same page without a refresh from drop down

snorcha

Hi guru's,

You know when you go to some websites and you select one item in a drop down list, and it says building selection, then displays a seperate list with all the results from the first selection. How is this done?

I know how to build menus that do this in javascript, but all the values must be present for it to build the second list. What I am hoping for is a way of selecting an item the first drop down, which then executes a query on the db and returns results for it.

Is this possible? Or am I dreaming?

Cheers.

LordShryku

You're dreaming. Kinda. If you want to do it without refreshing, you'll either have to load all the variables into a javascript array on the first load of the page, of you'll have to use frames/iframes.

snorcha

damn! - Thanks for your reply tho...

*pinches self to wakeup

solus

Or use ASP.Net

hides

LordShryku

Oh, I am so gonna slap you for that remark :p

snorcha

lol what have I started 🙂

Weedpacket

Yaaaah, who needs ASP.NET? Javascript w/ PHP is cross-platform and can do the same job.

amrigo

I have two select boxes in my form, the first is where i do select the cityes, from my state, the second is where i do display the streets names form the city that i have selected.

I need to get the city variable, selected on the first select box, to start the query that will generate the street names in the second select box.

How can it be done? with javascript onChange?