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.
}