ajax_zone_list.php

<?
include("sqlsrv_connect.php");
$params = array(trim($_POST['zone']));
$options =  array("Scrollable" => SQLSRV_CURSOR_KEYSET);
$sql = "select id,name from zone where zone =?";

$result = sqlsrv_query($conn, $sql, $params , $options );
if($result){
	echo '<option>請選擇</option>';
	while( $row = sqlsrv_fetch_array($result, SQLSRV_FETCH_NUMERIC) ){
		echo '<option value="'.$row[0].'">'.$row[1].'</option>';
	}
}else die(print_r( sqlsrv_errors(), true));
?>