updating problem when contain same ID
Posted: Wed Jun 11, 2003 1:05 am
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.
?>
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.
Code: Select all
<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......