my html code:
Code: Select all
<td>
<select name="DEPARTMENT" id="DEPARTMENT" value="{DEPARTMENT)">
<option>{DEPARTMENT}</option>
</select></td>
Code: Select all
$query= "SELECT dept_name FROM ticket_dept";
$result =mysql_query($query);
$system->check_mysql($result, $query, __LINE__, __FILE__);
$DEPARTMENT = mysql_fetch_array($result);
$template->assign_vars(array(
'DEPARTMENT' => $DEPARTMENT['dept_name'],
));
if you could make a suggestion, thanks a million