|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_eoffice/application/CA2/ |
Upload File : |
<?
@session_start() ;
require_once "config/config.ini.php";
require_once "common/database.class.php";
include("../../common/CA/class.openssl.php");
$db = new database();
$x=$db->connect();
if($_SERVER[REQUEST_METHOD] == "POST"){
$d=explode("/",$birth_date);
$birth_date=($d[2]-543)."-".$d[1]."-".$d[0];
if(!$action){
$strSQL="
INSERT INTO `ca_member` SET
`member_id`='$member_id',
`org_minitry`='$ministry',
`org_department`='$department',
`org_id`='$office_id',
`org_tel`='$org_tel',
`org_mobile`='$org_mobile',
`org_fax`='$org_fax',
`ps_prename_th`='$prename_th',
`ps_name_th`='$name_th',
`ps_surname_th`='$surname_th',
`ps_prename_en`='$prename_en',
`ps_name_en`='$name_en',
`ps_surname_en`='$surname_en',
`ps_birth_date`='$birth_date',
`ps_nationality`='$nationality',
`ps_race`='$country',
`ps_card_type`='$card_type',
`ps_card_ID`='$public_idcard',
`ps_home_no`='$address',
`ps_home_moo`='$address_info',
`ps_home_soi`='$personal_soi',
`ps_home_road`='$personal_road',
`ps_home_villa`='$personal_villa',
`ps_home_tambon`='$personal_tambon',
`ps_home_amphur`='$personal_amphur',
`ps_home_province`='$province_name',
`ps_home_zipcode`='$personal_zipcode',
`ps_home_tel`='$personal_tel',
`ps_home_fax`='$personal_fax',
`ps_home_mobile`='$personal_mobile'
";
}else{
$strSQL="
UPDATE `ca_member` SET
`org_minitry`='$ministry',
`org_department`='$department',
`org_id`='$office_id',
`org_tel`='$org_tel',
`org_mobile`='$org_mobile',
`org_fax`='$org_fax',
`ps_prename_th`='$prename_th',
`ps_name_th`='$name_th',
`ps_surname_th`='$surname_th',
`ps_prename_en`='$prename_en',
`ps_name_en`='$name_en',
`ps_surname_en`='$surname_en',
`ps_birth_date`='$birth_date',
`ps_nationality`='$nationality',
`ps_race`='$country',
`ps_card_type`='$card_type',
`ps_card_ID`='$public_idcard',
`ps_home_no`='$address',
`ps_home_moo`='$address_info',
`ps_home_soi`='$personal_soi',
`ps_home_road`='$personal_road',
`ps_home_villa`='$personal_villa',
`ps_home_tambon`='$personal_tambon',
`ps_home_amphur`='$personal_amphur',
`ps_home_province`='$province_name',
`ps_home_zipcode`='$personal_zipcode',
`ps_home_tel`='$personal_tel',
`ps_home_fax`='$personal_fax',
`ps_home_mobile`='$personal_mobile'
WHERE id='$id';
";
}
//echo "<pre>".$strSQL;die;
@mysql_query($strSQL);
echo "<meta http-equiv='refresh' content='0;url=ca_member_dashboard.php'>" ;
die;
}
?>
<html>
<head>
<title></title>
<META http-equiv=Content-Type content="text/html; charset=windows-874">
<SCRIPT language='javascript' src='daily_popcalendar.js'></SCRIPT>
<SCRIPT language='javascript' src='displayelement.js'></SCRIPT>
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.comment{
color:#F00;
}
INPUT{
FONT-SIZE: 12px; FONT-FAMILY: Tahoma, "Microsoft Sans ";
}
-->
</style>
<link href="css/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="10">
<tr>
<td align="center">
<script language="javascript">
function ValidateDoc()
{
var cr = unescape("\n");
var ErrorMsg = "เกิดข้อผิดพลาดดังนี้ : "+cr+cr;
var InitLen = ErrorMsg.length;
var TheForm = document.frm1;
var emailRegEx = /^[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$/i;
if (TheForm.office_id.value.length < 1)
ErrorMsg = ErrorMsg + "ชื่อส่วนราชการ " + cr;
if (TheForm.ministry.value.length < 1)
ErrorMsg = ErrorMsg + "กระทรวง " + cr;
if (TheForm.department.value.length < 1)
ErrorMsg = ErrorMsg + "กรม " + cr;
if (TheForm.org_tel.value.length < 1)
ErrorMsg = ErrorMsg + "โทรศัพท์ " + cr;
if (TheForm.prename_th.value.length < 1)
ErrorMsg = ErrorMsg + "คำนำหน้าชื่อ " + cr;
if (TheForm.name_th.value.length < 1)
ErrorMsg = ErrorMsg + "ชื่อ " + cr;
if (TheForm.surname_th.value.length < 1)
ErrorMsg = ErrorMsg + "นามสกุล " + cr;
if (TheForm.birth_date.value.length < 1)
ErrorMsg = ErrorMsg + "วันเดือนปีเกิด " + cr;
if (TheForm.country.value.length < 1)
ErrorMsg = ErrorMsg + "เชื้อชาติ " + cr;
if (TheForm.province_name.value.length < 1)
ErrorMsg = ErrorMsg + "จังหวัด " + cr;
if ( ErrorMsg.length > InitLen ){
alert( ErrorMsg );
return (false);
} return(false);
}
function genname(){
document.frm1.organization.value=document.frm1.prename.value+ ' '+document.frm1.fname.value+' '+document.frm1.lname.value
}
</script>
<SCRIPT LANGUAGE="JavaScript">
var xmlHttp;
function createXMLHttpRequest() {
if (window.ActiveXObject) {
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
else if (window.XMLHttpRequest) {
xmlHttp = new XMLHttpRequest();
}
}
function handleStateChange() {
if(xmlHttp.readyState == 4) {
if(xmlHttp.status == 200) {
updateproductList();
}
}
}
function updateproductList() {
clearproductList();
var department = document.getElementById("department");
var results = xmlHttp.responseText;
//alert(results);
var option = null;
p=results.split(",");
option = document.createElement("option");
option.setAttribute("value",0);
option.appendChild(document.createTextNode("ไม่ระบุ"));
department.appendChild(option);
for (var i = 0; i < p.length; i++){
if(p[i] > ""){
x = p[i].split("::");
option = document.createElement("option");
option.setAttribute("value",x[1]);
option.appendChild(document.createTextNode(x[0]));
department.appendChild(option);
}
}
}
function clearproductList() {
var department = document.getElementById("department");
while(department.childNodes.length > 0) {
department.removeChild(department.childNodes[0]);
}
}
function refreshproductList() {
var ministry = document.getElementById("ministry").value;
if(ministry == "" ) {
clearproductList();
return;
}
var url = "ajax_minitry.php?ministry_id=" + ministry;
createXMLHttpRequest();
xmlHttp.onreadystatechange = handleStateChange;
xmlHttp.open("GET", url, true);
xmlHttp.send(null);
}
function refreshproductListMAIN() {
var org_id = document.getElementById("office_id").value;
if(org_id == "" ) {
clearproductList();
document.getElementById("ministry").selectedIndex = 0;
return false;
}
var url = "ajax_minitryNsub.php?org_id=" + org_id +"&time=" + Math.random() ;
//alert(url);
createXMLHttpRequest();
xmlHttp.onreadystatechange = handleStateChangeMAIN;
xmlHttp.open("GET", url, true);
xmlHttp.send(null);
}
function handleStateChangeMAIN() {
if(xmlHttp.readyState == 4) {
if(xmlHttp.status == 200) {
updateproductListMAIN();
}
}
}
function updateproductListMAIN() {
clearproductList();
var department = document.getElementById("department");
var results = xmlHttp.responseText;
//alert(results);
var option = null;
pMAIN=results.split("///");
p=pMAIN[1].split(",");
option = document.createElement("option");
option.setAttribute("value",0);
option.appendChild(document.createTextNode(" - เลือกกรม - "));
department.appendChild(option);
q=pMAIN[0].split("::");
//alert(pMAIN[0]);
for (var i = 0; i < p.length; i++){
if(p[i] > "" ){
x = p[i].split("::");
option = document.createElement("option");
option.setAttribute("value",x[1]);
option.appendChild(document.createTextNode(x[0]));
department.appendChild(option);
}
}
if(q[3]!=""){ document.getElementById("ministry").selectedIndex = q[3]; }
if(q[4]!=""){ document.getElementById("department").selectedIndex = q[4]; }
}
// @date 2009/06/05 @by Kridsada
function clearTxt(sel, txt)
{
var index = sel.selectedIndex;
var selValue = sel.options[index].value;
if(selValue != "")
{
txt.value = "";
}
}
// @date 2009/06/05 @by Kridsada
function clearSel(txt, sel)
{
var value = txt.value;
if(value.length != 0)
{
sel.selectedIndex = 0;
}
}
</script>
<?php
if(empty($_POST['bt_submit'])){
if($id){
$strSQL="SELECT * from `ca_member` WHERE id ='$id' limit 1";
$result=@mysql_query($strSQL);
$row=@mysql_fetch_assoc($result);
$member_id=$id;
}
//echo "<pre>"; print_r($row); echo "</pre>";
?>
<form action="" method="post" name="frm1" onSubmit= "return ValidateDoc()">
<table width="700" border="0" cellspacing="0" cellpadding="5">
<tr>
<td colspan="3"><strong><u>กรุณากรอกข้อมูลให้ครบและถูกต้อง</u></strong></td>
</tr>
<? if(!$id){?>
<tr>
<td colspan="2" align="right"><span class="mainlevel">
</span>
</td>
<td width="144" align="right" class="mainlevel">
<nobr>
<input name="sign_type" id="new_member_type" type="radio" value="1" checked onClick="new_member()">
สมัครใหม่
<input name="sign_type" id="continue_member_type" type="radio" value="2" onClick="continue_member()">
ต่ออายุ
<script language="javascript">
function new_member(){
if(document.getElementById('new_member_type').checked==true){
document.getElementById('serail_number_tbl').style.display='none';
}
}
function continue_member(){
if(document.getElementById('continue_member_type').checked==true){
document.getElementById('serail_number_tbl').style.display='block';
}
}
</script> </td>
</tr>
<? }
$block=($row[member_id])?"block":"none";
?>
<tr id="serail_number_tbl" style="display:<?=$block?>">
<td width="160" align="right"> </td>
<td width="366" align="left" class="comment"> </td>
<td align="right" class="mainlevel">SERAIL NUMBER<br>
<input type="text" name="serail_number" value="<?=$row[serial_number]?>"></td>
</tr>
<tr>
<td colspan="3" align="left" bgcolor="#CCCCCC"><strong>ข้อมูลองค์กร</strong></td>
</tr>
<tr>
<td align="right" valign="top"><span class="link_back"><strong>ชื่อส่วนราชการ</strong></span></td>
<td colspan="2" align="left" class="comment">
<SELECT name="office_id" id="office_id" onChange="refreshproductListMAIN();" style="width:250px;">
<OPTION value=""> - ระบุหน่วยงาน - </OPTION>
<?
$sql_office = "SELECT * FROM org_staffgroup WHERE groupname NOT LIKE '%Guest%' AND groupname NOT LIKE '%Administrator%' ORDER BY groupname ASC"; // group_type == "1" คือเลือกเฉพาะที่เป็นหน่วยงานเท่านั้น
$Result_office = mysql_query($sql_office);
while($rs_of = mysql_fetch_assoc($Result_office)){
if($rs_of[gid] == $row[org_id]){ $sel = "selected";}else{ $sel = "";}
echo "<option value='$rs_of[gid]' $sel title='$rs_of[groupname]'>$rs_of[groupname]</option>";
}
?>
</SELECT>
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>กระทรวง</strong></td>
<td colspan="2" align="left" class="comment"><select name="ministry" id="ministry" onChange="refreshproductList();" style="width:250px;">
<option value="0"> - เลือกกระทรวง - </option>
<?
$sql_ministry = "SELECT * FROM ministry_lbl ORDER BY name ASC";
$result_ministry = mysql_query($sql_ministry);
while($rs_m = mysql_fetch_assoc($result_ministry)){
if($rs_m[moc_id] == $rs[alleg_ministry]){ $sel = "selected";}else{ $sel = "";}
echo "<option value='$rs_m[moc_id]' $sel>$rs_m[name]</option>";
}
?>
</select>
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>กรม</strong></td>
<td colspan="2" align="left" class="comment">
<SELECT name="department" id="department" style="width:250px;">
<OPTION value="0"> - เลือกกรม - </OPTION>
<?
$sql_dep = "SELECT * FROM department_lbl WHERE dev_id='$rs[alleg_department]'";
$result_dep = @mysql_query($sql_dep);
$rs_dep = @mysql_fetch_assoc($result_dep);
if($rs_dep[dev_id] != ""){ $sel = "selected";}else{ $sel = "";}
echo "<option value='$rs_dep[dev_id]' $sel>$rs_dep[name]</option>";
?>
</SELECT>
*
<?
if($row[org_id]){
echo "<script language=javascript>refreshproductListMAIN();</script>";
}
?>
</td>
</tr>
<tr>
<td align="right" valign="top"><strong>โทรศัพท์/TEL</strong></td>
<td colspan="2" align="left" class="comment"><input name="org_tel" type="text" style="width:250px;" id="org_tel" value="<?php echo "$row[org_tel]"; ?>"/>
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>โทรศัพท์มือถือ/MOBILE</strong></td>
<td colspan="2" align="left" class="comment"><input name="org_mobile" type="text" style="width:250px;" id="org_mobile" value="<?php echo "$row[org_mobile]"; ?>" /></td>
</tr>
<tr>
<td align="right" valign="top"><strong>โทรสาร/FAX</strong></td>
<td colspan="2" align="left" class="comment"><input name="org_fax" type="text" style="width:250px;" id="org_fax" value="<?php echo "$row[org_fax]"; ?>"/></td>
</tr>
<tr>
<td colspan="3" align="left"> </td>
</tr>
<tr>
<td colspan="3" align="left" bgcolor="#CCCCCC"><strong>ผู้รับผิดชอบข้อมูล</strong></td>
</tr>
<tr>
<td align="right" valign="top"><strong>คำนำหน้าชื่อ</strong></td>
<td colspan="2" align="left" class="comment"><input name="prename_th" type="text" style="width:250px;" id="prename_th" value="<?php echo "$row[ps_prename_en]"; ?>"/>
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>ชื่อ</strong></td>
<td colspan="2" align="left" class="comment"><input name="name_th" type="text" style="width:250px;" id="name_th" value="<?php echo "$row[ps_name_th]"; ?>"/>
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>นามสกุล</strong></td>
<td colspan="2" align="left" class="comment"><input name="surname_th" type="text" style="width:250px;" id="surname_th" value="<?php echo "$row[ps_surname_th]"; ?>"/>
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>PRENAME</strong></td>
<td colspan="2" align="left" class="comment"><input name="prename_en" type="text" style="width:250px;" id="prename_en" value="<?php echo "$row[ps_prename_en]"; ?>"/></td>
</tr>
<tr>
<td align="right" valign="top"><strong>NAME</strong></td>
<td colspan="2" align="left" class="comment"><input name="name_en" type="text" style="width:250px;" id="name_en" / value="<?php echo "$row[ps_name_en]"; ?>"></td>
</tr>
<tr>
<td align="right" valign="top"><strong>SURNAME</strong></td>
<td colspan="2" align="left" class="comment"><input name="surname_en" type="text" style="width:250px;" id="surname_en" value="<?php echo "$row[ps_surname_en]"; ?>"/>
</span></td>
</tr>
<tr>
<td align="right" valign="top"><strong>วันเดือนปีเกิด/BRITH DATE </strong></td>
<?
if($row[ps_birth_date]){
$d=explode("-",$row[ps_birth_date]);
$birth_date=$d[2]."/".$d[1]."/".($d[0]+543);
}
?>
<td colspan="2" class="comment">
<INPUT name="birth_date" type="text" onFocus="blur();" value="<?=($birth_date)?$birth_date:date("d/m/").(date("Y")+543)?>" style="width:125px;" readonly >
<INPUT name="button2" type="button" style='font-size:11px; width:80px;' onClick="popUpCalendar(this, form.birth_date, 'dd/mm/yyyy')" value='วัน เดือน ปี'>
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>เชื้อชาติ</strong></td>
<td colspan="2" class="comment">
<SELECT name="country" style="width:125px;" onChange="document.post.book_country.value=this.value">
<OPTION value="">- ระบุประเทศ -</OPTION>
<? // if(!$rs_person[country]){$rs_person[country]="LA";}?>
<?
$row[ps_race]=($row[ps_race])?$row[ps_race]:"THA";
$sql_nationality=" SELECT country_id as id, country_en as nationality_th FROM tbl_country order by id";
$result=mysql_query($sql_nationality);
while($rs_nationality=mysql_fetch_assoc($result)){
if($row[ps_race]==$rs_nationality[id]){$selected="selected";}else{$selected="";}
?>
<OPTION value="<?=$rs_nationality[id]?>" title="<?=$rs_nationality[nationality_en]?>" <?=$selected?>>
<?=$rs_nationality[id]?>
-
<?=$rs_nationality[nationality_th]?>
</OPTION>
<? }?>
</SELECT>
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>สัญชาติ</strong></td>
<td colspan="2" class="comment">
<SELECT name="nationality" style="width:125px;" disabled="disabled">
<OPTION value="">- ระบุสัญชาติ -</OPTION>
<?php
$row[ps_nationality]=($row[ps_nationality])?$row[ps_nationality]:"T03";
$sql_nationality=" SELECT * FROM tbl_nationality order by id";
$result=mysql_query($sql_nationality);
while($rs_nationality=mysql_fetch_assoc($result)){
if($row[ps_nationality]==$rs_nationality[id]){
$selected="selected";
}else{
$selected="";
}
?>
<OPTION value="<?=$rs_nationality[id]?>" title="<?=$rs_nationality[nationality_th]?>" <?=$selected?> ><?php echo $rs_nationality[id]."-".$rs_nationality[nationality_en];?> </OPTION>
<? }?>
</SELECT>
<input name="nationality" type="hidden" style="width:250px;" id="nationality" value="<?=$rs_person[nationality]?>" />
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>บัตร</strong></td>
<td colspan="2" class="comment">
<input name="card_type" id="PIN_card_selected" type="radio" value="1" onClick="pin_selected()" <?=($row[ps_card_type]==1||!$row[ps_card_type])?"checked":"";?> >
บัตรประจำตัวประชาชน
<input name="card_type" id="GOV_card_selected" type="radio" value="2" onClick="gov_selected()" <?=($row[ps_card_type]==2)?"checked":"";?>>
บัตรข้าราชการ
<script language="javascript">
function pin_selected(){
if(document.getElementById('PIN_card_selected').checked==true){
document.getElementById('PIN_card_tbl').style.display='block';
document.getElementById('GOV_card_tbl').style.display='none';
}
}
function gov_selected(){
if(document.getElementById('GOV_card_selected').checked==true){
document.getElementById('GOV_card_tbl').style.display='block';
document.getElementById('PIN_card_tbl').style.display='none';
}
}
function Filter_Keyboard() {
var keycode = window.event.keyCode;
if( keycode >=37 && keycode <=40 ) return true; // arrow left, up, right, down
if( keycode >=48 && keycode <=57 ) return true; // key 0-9
if( keycode >=96 && keycode <=105 ) return true; // numpad 0-9
if( keycode ==110 || keycode ==190 ) return true; // dot
if( keycode ==8 ) return true; // backspace
if( keycode ==9 ) return true; // tab
if( keycode ==45 || keycode ==46 || keycode ==35 || keycode ==36) return true; // insert, del, end, home
return false;
}
function checkID(id) {
if(id.length != 13) return false;
for(i=0, sum=0; i < 12; i++)
sum += parseFloat(id.charAt(i))*(13-i);
if((11-sum%11)%10!=parseFloat(id.charAt(12))) return false;
return true;
}
function checkPIN() {
if(document.getElementById('public_idcard').value != "" ){
if(!checkID(document.getElementById('public_idcard').value)){
alert('รหัสบัตรประชาชนไม่ถูกต้อง กรุณาตรวจอีกครั้ง !!');
return false;
}else{
return true;
}
}
}
</script> </td>
</tr>
<tr id="PIN_card_tbl" style="display:<?=($row[ps_card_type]==1)?"block":"none";?>">
<td align="right" valign="top"><strong>บัตรประจำตัวประชาชน</strong></td>
<td colspan="2" class="comment">
<INPUT name="public_idcard" type="text" id="public_idcard" maxlength="13" style="width:250px;" onBlur="return checkPIN();" onKeyDown="return Filter_Keyboard();" value="<?=($row[ps_card_type]==1)?$row[ps_card_ID]:""?>" >
<br>* ต้องระบุเลขบัตรประจำตัวประชาชน 13 หลักเท่านั้น </td>
</tr>
<tr id="GOV_card_tbl" style="display:<?=($row[ps_card_type]==2)?"block":"none";?>">
<td align="right" valign="top"><strong>บัตรข้าราชการ</strong></td>
<td colspan="2" align="left" class="comment"><input name="gov_idcard" maxlength="13" type="text" style="width:250px;" id="gov_idcard" onKeyDown="return Filter_Keyboard();" value="<?=($row[ps_card_type]==2)?$row[ps_card_ID]:""?>" />
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>โทรศัพท์/TEL</strong></td>
<td colspan="2" align="left" class="comment"><input name="personal_tel" type="text" style="width:250px;" id="personal_tel" value="<?php echo "$row[ps_home_tel]"; ?>"/>
*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>โทรศัพท์มือถือ/MOBILE</strong></td>
<td colspan="2" align="left" class="comment"><input name="personal_mobile" type="text" style="width:250px;" id="personal_mobile" value="<?php echo "$row[ps_home_mobile]"; ?>"/></td>
</tr>
<tr>
<td align="right" valign="top"><strong>โทรสาร/FAX</strong></td>
<td colspan="2" align="left" class="comment"><input name="personal_fax" type="text" style="width:250px;" id="personal_fax" value="<?php echo "$row[ps_home_fax]"; ?>"/></td>
</tr>
<tr>
<td align="right" valign="top"><strong>ที่อยู่</strong></td>
<td colspan="2" class="comment">
<input name="address" type="text" style="width:50px;" id="address" value="<?php echo "$row[ps_home_no]"; ?>"/>
<input name="address_info" type="text" style="width:195px;" id="address_info" value="<?php echo "$row[ps_home_moo]"; ?>" />
</span></td>
</tr>
<tr>
<td align="right" valign="top"><strong>ซอย</strong></td>
<td colspan="2" class="comment"><input name="personal_soi" type="text" style="width:250px;" id="personal_soi" value="<?php echo "$row[ps_home_soi]"; ?>"/>
</span></td>
</tr>
<tr>
<td align="right" valign="top"><strong>ถนน</strong></td>
<td colspan="2" class="comment"><input name="personal_road" type="text" style="width:250px;" id="personal_road" value="<?php echo "$row[ps_home_road]"; ?>"/>
</span></td>
</tr>
<tr>
<td align="right" valign="top"><strong>หมู่บ้าน</strong></td>
<td colspan="2" class="comment">
<input name="personal_villa" type="text" style="width:250px;" id="personal_villa" value="<?php echo "$row[ps_home_villa]"; ?>" />
</span></td>
</tr>
<tr>
<td align="right" valign="top"><strong>ตำบล</strong></td>
<td colspan="2" class="comment">
<input name="personal_tambon" type="text" style="width:250px;" id="personal_tambon" value="<?php echo "$row[ps_home_tambon]"; ?>" />
</span></td>
</tr>
<tr>
<td align="right" valign="top"><strong>อำเภอ</strong></td>
<td colspan="2" class="comment">
<input name="personal_amphur" type="text" style="width:250px;" id="personal_amphur" value="<?php echo "$row[ps_home_amphur]"; ?>"/>
</span></td>
</tr>
<tr>
<td align="right" valign="top"><strong>จังหวัด</strong></td>
<td colspan="2" class="comment">
<SELECT name="province_name" id="province_name" style="width:250px;">
<OPTION value=""> - เลือกจังหวัด - </OPTION>
<?
$sql_pro = "SELECT * FROM tbl_province ORDER BY $db_master.tbl_province.province ASC";
$result_pro = mysql_query($sql_pro);
while($rs_pro = mysql_fetch_assoc($result_pro)){
if($row[ps_home_province] == $rs_pro[id]){ $sel = "selected='selected'";}else{ $sel = "";}
echo "<option value='$rs_pro[id]' $sel>$rs_pro[province]</option>";
}
?>
</SELECT>
</span>*</td>
</tr>
<tr>
<td align="right" valign="top"><strong>รหัสไปรณีย์</strong></td>
<td colspan="2" class="comment">
<input name="personal_zipcode" type="text" style="width:250px;" id="personal_zipcode" value="<?php echo "$row[ps_home_zipcode]"; ?>"/>
</span></td>
</tr>
<tr>
<td align="right"> </td>
<td colspan="2"> <input type="hidden" name="member_id" value="<?=$member_id?$member_id:"";?>" >
<input type="hidden" name="id" value="<?=$row[id]?$row[id]:$id;?>" >
<input type="hidden" name="action" value="<?=$action?$action:"";?>" ></td>
</tr>
<tr>
<td colspan="3" align="center"><input name="bt_submit" type="submit" value="ลงทะเบียน"/>
<label>
<input type="reset" name="Reset" id="button" value="ยกเลิก" onClick="window.location='ca_member_dashboard.php'" >
</label></td>
</tr>
</table>
</form>
<?php
}//endif
?>
</td>
</tr>
</table>
</body>
</html>