Code: Select all
<option value="<?php echo $e_dept; ?>" <? echo (isset($_POST['select_dept']) && $_POST['select_dept'] == $row['select_dept'] ? ' selected="selected' : '');?>> <?php echo $e_dept; ?> </option>Moderator: General Moderators
Code: Select all
<option value="<?php echo $e_dept; ?>" <? echo (isset($_POST['select_dept']) && $_POST['select_dept'] == $row['select_dept'] ? ' selected="selected' : '');?>> <?php echo $e_dept; ?> </option>Code: Select all
<form name="select_dept" action="/admin/users.php" method="post">
<select name="select_dept" onchange="this.form.submit();">
<option value="0" selected>Select Dept</option>
<option value="<?php echo $e_dept; ?>" <? echo (isset($_POST['select_dept']) && $_POST['select_dept'] == $row['select_dept'] ? ' selected="selected' : '');?>> <?php echo $e_dept; ?> </option>
<?php
include("conection.php");
$query = "select DISTINCT(e_dept) from tbl_emp";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
$e_dept = $row['e_dept'];
?>
<option value="<?php echo $e_dept; ?>"> <?php echo $e_dept; ?> </option>
<?php
}
?>
</select>
<input type="hidden" name="s_id" value="<?php echo "$s_id"; ?>">
</form>