01.<table id="ability_table" class="table table-bordered display nowrap" style="width:100%">
02. <thead class="thead-dark">
03. <br/>
04. <h5 align="center">ตารางแสดงข้อมูลความสามรถพิเศษ</h5>
05. <tr>
06. <th>ภาษา</th>
07. <th>กีฬา</th>
08. <th>คอมพิวเตอร์</th>
09. <th>ศิลปะ/ดนตรี</th>
10. <th>ออกแบบ/ตัดต่อ</th>
11. <th>ยุทธวิธี</th>
12. <th>อื่นๆ</th>
13. </tr>
14. </thead>
15. <tbody>
16. <?php
17. $sql ="SELECT ability_name AS lang FROM tb_ability where type_id='1'AND id_card='2db85708fc455aa574d5b15ad8fef134';";
18. $sql .="SELECT ability_name AS sport FROM tb_ability where type_id='2' AND id_card='2db85708fc455aa574d5b15ad8fef134';";
19. $sql .="SELECT ability_name AS com FROM tb_ability where type_id='4' AND id_card='2db85708fc455aa574d5b15ad8fef134';";
20. $sql .="SELECT ability_name AS art FROM tb_ability where type_id='3' AND id_card='2db85708fc455aa574d5b15ad8fef134';";
21. $sql .="SELECT ability_name AS design FROM tb_ability where type_id='5'AND id_card='2db85708fc455aa574d5b15ad8fef134';";
22. $sql .="SELECT ability_name AS tactic FROM tb_ability where type_id='6'AND id_card='2db85708fc455aa574d5b15ad8fef134';";
23. $sql .="SELECT ability_name AS etc FROM tb_ability where type_id='7' AND id_card='2db85708fc455aa574d5b15ad8fef134'";
24.
25.
26.if (mysqli_multi_query($con, $sql)) {
27. do {
28.
29. if ($result = mysqli_store_result($con)) {
30. while ($row = mysqli_fetch_assoc($result)) {
31.?>
32.<tr>
33. <td><?=$row['lang'];?></td>
34. <td><?=$row['sport'];?></td>
35. <td><?=$row['com'];?></td>
36. <td><?=$row['art'];?></td>
37. <td><?=$row['design'];?></td>
38. <td><?=$row['tactic'];?></td>
39. <td><?=$row['etc'];?></td>
40.</tr>
41.<?php
42. }
43. mysqli_free_result($result);
44. }
45.
46. } while (mysqli_next_result($con));
47.} ?>
