ช่วยดูให้หน่อยค่ะไฟล์แก้ไขการจอง ตอนเพิ่มรายการจองลงฐานข้อมูลจะบันทึกเป็นปีเดือนวัน คือ 2557-03-20

<?php
session_start();
	$serviceID = $_REQUEST["serviceID"];
	$_SESSION["serviceID"]=$serviceID;
$ses_userID =$_SESSION["ses_userID"];
if($ses_userID  ==""){
	?>
<script language="javascript">alert("กรุณาเข้าสู่ระบบ");</script>
<script language="JavaScript"> document.location.href="login_admin.php"; </script>
 <?php        
}	else 
?>
<meta http-equiv="Content-Type" content="text/html; charset=tis-620" />
<link href="admin/css/style.css" rel="stylesheet" type="text/css" />
<link href="admin/calendar-mos.css" rel="stylesheet" type="text/css"> 
<script language="JavaScript" src="admin/calendar.js">
</script>
<?php include("header2.php"); ?>                    
<?php include("menuuser_login.php"); ?>        
    
<?php include("config.php");
$sql="select*from reservroom";
$sql.= " inner join tblclass on (reservroom.classID = tblclass.classID)";
$sql.= " inner join tbldepartments on (reservroom.departmentsID = tbldepartments.departmentsID)";
$sql.= " inner join tblbranch on (reservroom.branchID = tblbranch.branchID)";
$sql.="where serviceID='$serviceID'";

$dbquery=mysql_query($sql,$conn) or die ("sql ผิดพลาด");
$num_rows=mysql_num_rows($dbquery);
$data=mysql_fetch_array($dbquery);
if($num_rows==1)
	{
$subject=$data["subject"];
$dateSave=$data["dateSave"];
$dateService=$data["dateService"];
$timeIn=$data["timeIn"];
$timeIn1= $data["timeIn"];
$timeIn2 = $data["timeIn"];
$timeOut=$data["timeOut"];
$timeOut1 = $data["timeOut"];
$timeOut2 = $data["timeOut"];
$userID=$data["userID"];
$classID=$data["classID"];
$className=$data["className"];
$departmentsID=$data["departmentsID"];
$departments=$data["departments"];
$branchID=$data["branchID"];
$branch=$data["branch"];
$amount=$data["amount"];
$equipment=$data["equipment"];
$detail=$data["detail"];
	}
else
{
	echo "&nbsp;";
}
?>