<?php
//--Class Amphur--------------------------

include_once "clsbase_Amphur.php";

class Amphur extends base_Amphur{

function RSAmphurByPvNameAndApName($pvName, $apName){
	$sql = "select * from Province p, Amphur a 
			where p.provinceName like '%$pvName%' and p.provinceId=a.provinceId 
			and a.amphurName like '%$apName%' order by p.provinceName, a.amphurName";
	$this->SetQuery($sql);
}

function RSAmphurByPvNameAndApNameLimit($pvName, $apName, $start, $pageSize){
	$sql = "select * from Province p, Amphur a 
			where p.provinceName like '%$pvName%' and p.provinceId=a.provinceId 
			and a.amphurName like '%$apName%' order by p.provinceName, a.amphurName 
			limit $start, $pageSize";
	$this->SetQuery($sql);
}

} //--End class Amphur--
?>