[RESOLVED] querying db with javascript?

[lucilue2003]

I have a drop down of states. If they choose a state like CA, then i want anothe drop down to appear that is populated with all the schools names in California.

Friendster.com does somthing similar in their regisrer page.

Is there a way to use javascript to call a php page to have it populate the information ?

Thanks. (withouth using Iframe or frames)

[dalecosp]

This is really a javascript question, and not a javascript forum.

Javascript can't query the server database, per se. Not without calling some page, which would have to be re-served in PHP's case.

I've read some articles on the collapsible stuff like you mention ... the arrays are populated on the original page load, unless they can be constructed by JS logic. It appears that in Friendster's case, they use Javascript to read an XML file on their server to populate the list. You can view their source. Pretty neat idea, but no PHP nor database involved, unless PHP or some similar technology is actually creating the XML files "on the fly".

[mrfritz379]

You're probably going to want to look up information on Ajax or XMLHTTPRequest. You'd be making a call back to some page on the server (a php script) which can pass back the list of schools to the javascript. Javascript can then populate the drop down list.