<tr>
<td><b><?php
echo msg('userpage_department');
?>
</b></td>
<td colspan=3>
<select name="department" <?php
echo $mode;
?>
>
<?php
// query to get a list of departments
$query = "SELECT id, name FROM {$GLOBALS['CONFIG']['db_prefix']}department ORDER BY name";
$result = mysql_query($query, $GLOBALS['connection']) or die("Error in query: {$query}. " . mysql_error());
$userdepartment = $user_obj->getDeptID();
while (list($id, $name) = mysql_fetch_row($result)) {
if ($id == $userdepartment) {
echo '<option selected value="' . $id . '">' . $name . '</option>';
} else {
echo '<option value="' . $id . '">' . $name . '</option>';
}
}
mysql_free_result($result);
?>
</select>
</td>
</tr>
<tr>
<td><b><?php
echo msg('userpage_admin');
