01.<?php
02.$sql ="SELECT * FROM druguser";
03.$sql.= " inner join m_drug on (druguser.drug1ID = m_drug.drugID)";
04.$result = mysql_query($sql,$conn)
05. or die("ไม่สามารถดึงข้อมูลจากตาราง druguser ได้".mysql_error());
06.$i=1;
07. while($data=mysql_fetch_array($result)) {
08.?>
09. <tr>
10. <td align="center"><input name="chkDel[]" type="checkbox" value="<?php $data["drugUserID"];?>" /></td>
11. <td align="center"><div align="left">
12. <div align="center"><?php echo $data["drugUserID"];?></div>
13. <div align="center"></div>
14. <div align="center"></div><div align="center"></div></div></td>
15. <td align="center"><?php echo $data["serviceID"];?></td>
16. <td align="center"><?php echo $data["drugName"];?></td>
17. <td align="center"><?php echo $data["number1"];?></td>
18. <td align="center"><?php echo $data["drugName"];?></td>
19. <td align="center"><?php echo $data["number2"];?></td>
20. <td align="center"><?php echo $data["drugName"];?></td>
21. <td align="center"><?php echo $data["number3"];?></td>
