"; $html.="Select Country"; $qur=mysql_query("select * from countries"); while($country=mysql_fetch_array($qur)){ $html.="".$country['name'].""; } $html.=""; echo $html; } if(!empty($_POST['state'])&& empty($_POST['city'])){ $html=''; $html.=""; $html.="Select State"; $country=!empty($_POST['country'])?$_POST['country']:'IN'; $conqur=mysql_query("select * from countries where v_iso_2='".$country."'");; $condetail=mysql_fetch_array($conqur); $qur=mysql_query("select * from states where i_country_id='".$condetail['id']."'"); while($state=mysql_fetch_array($qur)){ $html.="".$state['v_name'].""; } $html.=""; echo $html; } if(!empty($_POST['city'])){ $html=''; $html.=""; $html.="Select City"; $state=!empty($_POST['state'])?$_POST['state']:"Gujarat"; $conqur=mysql_query("select * from states where v_name='".$state."'");; $condetail=mysql_fetch_array($conqur); $qur=mysql_query("select * from cities where i_state_id='".$condetail['i_id']."'"); while($city=mysql_fetch_array($qur)){ $html.="".$city['v_name'].""; } $html.=""; echo $html; } ?>