001.<?php
002.
003.
004.
005.$objConnect = mysql_connect("localhost","root","12345678") or die("Error Connect to Database");
006.$objDB = mysql_select_db("es_db");
007.
008.
009.
010.if($_POST["hdnCmd"] == "Update")
011.{
012. $strSQL = "UPDATE employee SET ";
013. $strSQL .="uniform_size = '".$_POST["txtSize"]."' ";
014. $strSQL .="WHERE id = '".$_POST["hdnEditID"]."' ";
015. $objQuery = mysql_query($strSQL);
016. if(!$objQuery)
017. {
018. echo "Error Update [".mysql_error()."]";
019. }
020.
021.
022.}
023.
024.
025.$strSQL = "SELECT * FROM employee where hireDate between '2019-06-03' and '2019-06-03'";
026.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
027.?>
028.
029.<form name="frmMain" method="post" action="<?php echo $_SERVER["PHP_SELF"];?>">
030.<input type="hidden" name="hdnCmd" value="">
031.<table width="80%" align="center" cellpadding="0" cellspacing="1" bgcolor="#3D3B3B">
032. <tr bgcolor="#FFFFFF">
033. <th width="80"> <div align="center">EN </div></th>
034. <th width="100"> <div align="center">Hire Date</div></th>
035. <th width="100"> <div align="center">Probation Date</div></th>
036. <th width="200"> <div align="center">Name-LastName</div></th>
037. <th width="150"> <div align="center">BU </div></th>
038. <th width="150"> <div align="center">Supervisor </div></th>
039. <th width="100"> <div align="center">Building </div></th>
040. <th width="50"> <div align="center">Gender </div></th>
041. <th width="100"> <div align="center">Uniform Size </div></th>
042. <th width="100"> <div align="center">Edit </div></th>
043.
044. </tr>
045.<?php
046.while($objResult = mysql_fetch_array($objQuery))
047.{
048.?>
049.
050. <?php
051. if($objResult["id"] == $_GET["ID"] and $_GET["Action"] == "Edit")
052. {
053. ?>
054. <tr bgcolor="#FFFFFF">
055. <td>
056. <div align="center">
057. <?php echo $objResult["id"];?>
058. <input type="hidden" name="hdnEditID" size="5" value="<?php echo $objResult["id"];?>">
059. </div>
060. </td>
061. <td><?php echo $objResult["hireDate"];?></td>
062. <td><?php echo $objResult["probation_date"];?></td>
063. <td><div align="center"><?php echo $objResult["full_name"];?></div></td>
064. <td align="left"><?php echo $objResult["BU"];?></td>
065. <td align="left"><?php echo $objResult["supervisor"];?></td>
066. <td align="left"><?php echo $objResult["building"];?></td>
067. <td align="left"><?php echo $objResult["gender"];?></td>
068. <td align="left"><input type="text" name="txtSize" size="5" value="<?php echo $objResult["uniform_size"];?>"></td>
069. <td colspan="2" align="left"><div align="center">
070. <input name="btnAdd" type="button" id="btnUpdate" value="Update" OnClick="frmMain.hdnCmd.value='Update';frmMain.submit();">
071. <input name="btnAdd" type="button" id="btnCancel" value="Cancel" OnClick="window.location='<?php echo $_SERVER["PHP_SELF"];?>';">
072. </div></td>
073. </tr>
074. <?php
075. }
076. else
077. {
078. ?>
079. <tr bgcolor="#FFFFFF">
080. <td><div align="center"><?php echo $objResult["id"];?></div></td>
081. <td> <?php echo $objResult["hireDate"];?></td>
082. <td> <?php echo $objResult["probation_date"];?></td>
083. <td><div align="left"> <?php echo $objResult["full_name"];?></div></td>
084. <td align="left"> <?php echo $objResult["BU"];?></td>
085. <td align="left"> <?php echo $objResult["supervisor"];?></td>
086. <td align="left"> <?php echo $objResult["building"];?></td>
087. <td align="left"> <?php echo $objResult["gender"];?></td>
088. <td align="left"> <?php echo $objResult["uniform_size"];?></td>
089. <td align="center"><a href="<?php echo $_SERVER["PHP_SELF"];?>?Action=Edit&ID=<?php echo $objResult["id"];?>">Edit</a></td>
090.
091. </tr>
092. <?php
093. }
094. ?>
095.<?php
096.}
097.?>
098.
099.</table>
100.</form>
101.<?php
102.mysql_close($objConnect);
103.?>
104.</body>
105.</html>
แต่ติดปัญหาตรงที่ หากรับค่า วันที่ มา where หา ข้อมูลก็ขึ้นปกติ 
