[theighost]

i am using code igniter in the website i'm working on and i need php combined with any language to do:

for example i have a dropdown list named states that takes its values from a data base, and i have another dropdown list named cities that has its values from a database also.

when i click on a state the city dropdown list should show the cities in that state only.

i read that i need ajax...which i dont know hot to use

any hints or scripts?

[Keith]

AJAX would probably be the best way to go. With a solution like this, 10 developers will give you 10 solutions, all differing in method but all ultimately achieving the same goal.

I would suggest you look into JavaScript libraries such as Mootools, Prototype, jQuery, etc, and use their pre-developed solutions for AJAX requests. Just read up on the documentation.

I would also personally recommend using PHP's json_encode() function coupled with Mootools' Request and JSON classes. Make a GET or POST request to a PHP file to return the cities as a JSON-encoded array, decode the array with JSON.decode(), and write the select with the resulting object.