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>
Load balance : Server 05
Quote:
