ajgkqsldxvkqsldkqs azelfkqsmkqsmlkdqsmld azmlekdqmskdmlqskd nkldsfkqsmldkqsmdmlskd  0); $session = $mcrypt->decrypt($_GET['id']); $region = $mcrypt->decrypt($_GET['region']); /* Fetch the information */ $con = db_connect(); $sql = session($con,$session); if(db_rows($con,$sql)>0){ /* fetch userid and create session token */ $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $userid = $row['userid']; } $towns = array(); /* Fetch regions */ array_push($towns,array('name'=>$mcrypt->encrypt("Select"), 'code'=>$mcrypt->encrypt(" ") ) ); $sql = "select * from towns where region='".escape($con,$region)."' order by town asc"; $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $name = $row['town']; $code = $row['code']; array_push($towns,array('name'=>$mcrypt->encrypt($name), 'code'=>$mcrypt->encrypt($code) ) ); } } echo json_encode(array("towns"=>$towns)); db_close($con); }