code ในส่วนของ controller ค่ะ
โค้ด: เลือกทั้งหมด
$sql_ary = array(
'SELECT' => 'p.PROVINCE_NAME,u.AMPHUR_NAME,t.DISTRICT_NAME,u.POSTCODE ',
'FROM' => array(
'mod_province' => 'p',
'mod_amphur' => 'u',
'mod_district'=> 't'
),
'WHARE' => 'p.PROVINCE_ID = u.PROVINCE_ID'
.'AND u.AMPHUR_ID = t.AMPHUR_ID '
);
$sql = $db->sql_build_query('SELECT', $sql_ary);
$result = $db->sql_query( $sql);
while ($row = $db->sql_fetchrow($result)) {
$id = $row['PROVINCE_ID'];
$province = $row['PROVINCE_NAME'];
$district = $row['AMPHUR_NAME'];
$subdistrict = $row['DISTRICT_NAME'];
$zipcode = $row['POSTCODE'];
$this->template->assign_block_vars('m_thai', array(
'PROVINCE_ID' => $id,
'PROVINCE_NAME' => $province,
'AMPHUR_NAME' => $district,
'DISTRICT_NAME' => $subdistrict,
'POSTCODE' => $zipcode,
));
}