?>
</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>
