1#@!#!123s

��JFIF�� 1#@!#!123s

: / home4 / mcspunei / public_html / shubhamangal.co.in / admin /

Filename : ajax_category.php

back

<?php  
include "../includes/config.php";

if(isset($_REQUEST['id']))
{
$id = addslashes($_REQUEST['id']);
$sql = "SELECT * FROM skadate_location_state WHERE Country_str_code= '$id' order by Admin1_str_name asc";
$query = $db->get_all_assoc($sql);
?>

<select name="state" onchange="Javascript:citylist(this.value);"  class="quick-search_select-input2" style="width:145px;">
<option value=''>Select State</option>
<?php  
foreach($query as $sub)
{
?>
 <option value="<?php   echo $sub['Admin1_str_code'];?>"><?php   echo $sub['Admin1_str_name']; ?></option>
<?php   
}?>
</select>
<?php   } ?>

<?php   
if(isset($_GET['q'])) 
{
$id = addslashes($_GET['q']);

$sql = "SELECT distinct(Feature_str_name) FROM `skadate_location_city` WHERE `Admin1_str_code` = '$id' order by Feature_str_name asc";
$query = $db->get_all_assoc($sql);
?>
<select name="city" onchange="Javascript:cityzip(this.value);" class="quick-search_select-input2" style="width:145px;">
<option value='' style="font-style:italic;">Select City</option>
<?php  
foreach($query as $sub)
{
?>
 <option value="<?php echo $sub['Feature_str_name'];?>"><?php   echo $sub['Feature_str_name'];?></option>
<?php   
}?>
</select>


<?php   } ?>