Thailand Post Code by Mr. Deawx (AJAX) พอดีวันก่อนได้คุยกับพี่เดี่ยว (deawx)

<? 
require_once('dbcon.php');  
$page = $_POST['page'];
$rp = $_POST['rp'];
$sortname = $_POST['sortname'];
$sortorder = $_POST['sortorder'];

if (!$sortname) $sortname = 'id';
if (!$sortorder) $sortorder = 'desc';
		if($_POST['query']!=''){
			$where = "WHERE `".$_POST['qtype']."` LIKE '%".$_POST['query']."%' ";
		} else {
			$where ='';
		}
		if($_POST['letter_pressed']!=''){
			$where = "WHERE `".$_POST['qtype']."` LIKE '".$_POST['letter_pressed']."%' ";	
		}
		if($_POST['letter_pressed']=='All'){
			#$where = "WHERE `".$_POST['qtype']."` REGEXP '[[:digit:]]' ";
			$where ='';
		}
$sort = "ORDER BY $sortname $sortorder";

if (!$page) $page = 1;
if (!$rp) $rp = 10;

$start = (($page-1) * $rp);

$limit = "LIMIT $start, $rp";

$sql = "SELECT * FROM postcode $where $sort $limit";
$result = runSQL($sql);

$total = countRec('id','postcode',$where);


header("Expires: Mon, 23 Feb 2009 05:00:00 GMT" );
header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
header("Cache-Control: no-cache, must-revalidate" );
header("Pragma: no-cache" );
header("Content-type: text/x-json");

$data['page'] = $page;
$data['total'] = $total;

while ($row = mysql_fetch_object($result)) {
		$rows[] = array(
				"id" => $row->id,
				"cell" => array(
				$row->id
				,$row->PostCode
				,$row->Amphur
				,$row->Province
				,$row->Note
				,$row->PostOffice
				));
}
$data['rows'] = $rows;
echo json_encode($data);
?>