01.$sql = "select * from evtl_dept Order By EVTL_Dept_No";
02.$dbquery = mysql_db_query(log_event, $sql);
03.
04.
05.$num_rows = mysql_num_rows($dbquery);
06.
07.$i=0;
08.while ($i < $num_fields)
09. {
10. $field_name[$i] = mysql_field_name($dbquery, $i);
11. echo "<Td bgcolor=skyblue>".$field_name[$i]."</Td>";
12. $i++;
13. }
14.
15.
16.$i=0;
17.while ($i < $num_rows)
18. {
19. $result = mysql_fetch_array($dbquery);
20. $EVTL_Dept_No = $result[EVTL_Dept_No];
21. $EVTL_Dept_Name = $result[EVTL_Dept_Name];
22. echo "<input type='checkbox' name='EVTL_Dept_No' value='$EVTL_Dept_No'> $EVTL_Dept_Name<br>";
23. $i++;
24. }
Load balance : Server 02
