i need to select out the people who take OT in the date like 6/6 until 10/6.
below is the code to display the people. So maybe people take OT in 6/6 and 8/6 . so will display 2 time in table. The problem is when i update the status of the people. i can't find out which people was updated. i was use " empid" as unique ID already, but in a query maybe contain a people got 2 record but different date. when only update one of the record, system cannot find out which record was updated.
<td>'.$empid.'</td><td><div align="center">
<select name="status['.$empid.']"></select>
<td>'.$row[APPLY_DATE].' ~ '.$row[DATE_TO].'</td>
anyone can help me ? thank a lot......