dynamically loading cities

FirEwAteR

Hi, I'm looking to make a page that dynamically loads cities according to the country/state selected on the same page. Is there anyway to do this without using javascript? All of the cities/states are stored in a database. A tutorial would be greatly appreciated. Thanks for any help.
-Cody

leatherback

Hi,

You might want to look through the forum every once in a while before asking question.

This thread deals with the same issue, If I am not mistaken.

J./

FirEwAteR

that is a similar problem, but I need it to populate into an option input area in a form. And it needs to pull it from a database, not an XML file.

FirEwAteR

I would like to be able to use something like this:

function loadState(id) {
      var s;  

	  var stateName;
	  var cstate = new Array(); 

 if(id==2){
		 <? //get states list from database
		$sqlState="select * from ae_states where country_id=2 order by state_name ASC";
		$reState=mysql_query($sqlState);
		$sct = mysql_num_rows($reState);

		$k=0;  
		while($rowState = mysql_fetch_array($reState)) {  ?>
		   s=<?=$k?>;
		   stateName='<? echo $rowState["state_name"]; ?>';
		   cstate[s]=stateName;
	    	<? $k=$k+1;
		} ?>

 	    var len = cstate.length;
        cstate[len]="All states";
	    var field2 = document.frm_advSearch.asrch_state;
	    for(j=0; j<len+1; j++){
			newOpt=cstate[j];
			field2.length=j+1;
			field2.options[j]= new Option(newOpt,newOpt);
		} 
 }

But make the where clause dyncamically select using the id parsed from the country option input.

thorpe

you cant mix php and javascript together like that. php happens (on the server) before the javascript is ever even created (on the client).

if you really must do it this way, you'll need to look into using something like the xmlHttpRequest object for javascript.

personally, unless you really must get this stuff from a db, i would just do the whole thing client side.