01.
<table
class
=
"table"
>
02.
<thead>
03.
<tr>
04.
<th>ลำดับ</th>
05.
<th>รายการแข่งขัน</th>
06.
<th>ชื่อ-สกุล</th>
07.
<th>สาขาที่สอน</th>
08.
<th>วิทยาลัยที่สอน</th>
09.
<th>เบอร์โทรศัพท์</th>
10.
</tr>
11.
</thead>
12.
13.
<tbody>
14.
<?php
15.
$sql
=
"select tb_teacher.id, tb_teacher.S_ID, tb_teacher.prefix, tb_teacher.firstname, tb_teacher.lastname, tb_teacher.major,tb_teacher.sc_name,tb_teacher.tel, tb_subject.S_NAME, tb_level.L_NAME_S "
;
16.
$sql
=
$sql
.
"from tb_teacher inner join "
;
17.
$sql
=
$sql
.
"tb_subject on tb_teacher.S_ID = tb_subject.S_ID inner join "
;
18.
$sql
=
$sql
.
"tb_level on tb_subject.S_ID = tb_level.L_ID "
;
19.
$sql
=
$sql
.
"where tb_teacher.status_id = 1 "
;
20.
$sql
=
$sql
.
"order by tb_subject.L_ID, tb_teacher.id asc "
;
21.
$j
= 1;
22.
$query
= mysql_query(
$sql
);
23.
while
(
$result
= mysql_fetch_array(
$query
)){
24.
?>
25.
<tr>
26.
<td><?=
$j
;?></td>
27.
<td><?=
$result
[
"S_NAME"
];?> ระดับ <?=
$result
[
"L_NAME_S"
];?></td>
28.
<td><?=
"อ."
.
$result
[
"firstname"
].
" "
.
$result
[
"lastname"
];?></td>
29.
<td><?=
$result
[
"major"
];?></td>
30.
<td><?=
$result
[
"sc_name"
];?></td>
31.
<td><?=
$result
[
"tel"
];?></td>
32.
</tr>
33.
<?php
34.
$j
=
$j
+ 1;
35.
}
36.
?>
37.
</tbody>
38.
</table>