<?php 
ob_start();
require_once("includes/dbsmain.inc.php");
?>
<?php
$country_name=$_REQUEST['country_name'];
$type=$_REQUEST['type'];


$state_name="";
$state_fun_name="";
$state_error="";

if($type=="shipping")
{
$state_name="ship_state";
$state_fun_name="selectStateShip";
$state_error="error_state_ship";
}

if($type=="billing")
{
$state_name="billing_state";
$state_fun_name="selectStateBilling";
$state_error="error_state_billing";
}

$country_id=db_scalar("select id from countries where name='$country_name'");
//if($country=='India'){

$query="select * from states where 1 and country_id='$country_id' ORDER BY name";
$result=db_query($query);
?>



   <label class="label">State *</label>
<select class="checkout-input" class="niceselect_option" name="<?=$state_name?>" id="<?=$state_name?>" onchange="<?=$state_fun_name?>(this.value);">
<option value="">--- Choose State ---</option>
<? while($statedata=mysqli_fetch_array($result)) { ?>
<option value="<?=$statedata['name']?>" ><?=$statedata['name']?></option>
<?}
?>
</select>
 <p id="error_style_ship" class="<?=$state_error?>" style="width:260px;"></p>