?> </option> <?php } ?> </select> </td> </tr> <tr> <td>Type of Unit:</td> <td> <select name='unit_type'> <?php $db = retrieveHelpdeskDb("primary"); $sql = "select * from computer order by sequence"; $rs = $db->query($sql); $nm = $rs->num_rows; for ($i = 0; $i < $nm; $i++) { $row = $rs->fetch_assoc(); ?> <option value='<?php echo $row['id']; ?> '><?php echo strtoupper($row['unit']); ?> </option>
<?php session_start(); ini_set("date.timezone", "Asia/Kuala_Lumpur"); require "form functions.php"; require "db_page.php"; $_SESSION['helpdesk_page'] = "main page.php"; ?> <?php if (isset($_POST['location']) && isset($_POST['task_id'])) { $loginHour = adjustTime($_POST['loginamorpm'], $_POST['loginHour']); $loginDay = $_POST['loginYear'] . "-" . $_POST['loginMonth'] . "-" . $_POST['loginDay']; $login_date = $loginDay . " " . $loginHour . ":" . $loginMinute . ":00"; $db = retrieveHelpdeskDb(); $sql = "insert into dispatch_track(dispatch_staffer,login_time,location,task_id) values ('" . $_POST['user_name'] . "','" . $login_date . "',\"" . $_POST['location'] . "\",'" . $_POST['task_id'] . "')"; $rs = $db->query($sql); echo "Dispatch staffer has updated his status.<br>"; } ?> <style type="text/css"> #cssTable { background-color: #0066cb; color: #ffcc35; } a:link { text-decoration: none; } #exception a{
?> </option> <?php } ?> </select> </td> </tr> <tr> <td>Type of Unit:</td> <td> <select name='unit_type'> <?php $db = retrieveHelpdeskDb("secondary"); $sql = "select * from computer"; $rs = $db->query($sql); $nm = $rs->num_rows; for ($i = 0; $i < $nm; $i++) { $row = $rs->fetch_assoc(); ?> <option value='<?php echo $row['id']; ?> '><?php echo $row['unit']; ?> </option>