<? if($_GET["ProID"] != "") { // Search By Name or Email $strSQL = "SELECT * "; $strSQL .= "FROM drug as d"; $strSQL .= " WHERE (d.Drug_Status LIKE '".$_GET["ProID"]."' AND d.Drug_No LIKE '%".$_GET["DisID"]."%')"; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); $D_Drug_Status=$objResult["Drug_Status"]; $D_Drug_Name=$objResult["Drug_Name"]; $D_Drug_No=$objResult["Drug_No"]; ?> <table width="800" border="1"> <tr> <th width="5%"> <div align="center">Drug No </div></th> <th width="10%"> <div align="center">Drug Name </div></th> <th width="5%"> <div align="center">Drug Status </div></th> <th width="5%"> <div align="center">Item No </div></th> <th width="40%"> <div align="center">Item Name </div></th> <th width="5%"> <div align="center">Method No </div></th> <th width="40%"> <div align="center">Method Name </div></th> <tr> <? while($objResult = mysql_fetch_array($objQuery)) { ?> <tr> <td><div align="center"><?=$objResult["Drug_No"];?></div></td> <td><div align="center"><?=$objResult["Drug_Name"];?></div></td> <td><div align="center"><?=$objResult["Drug_Status"];?></div></td> </tr> <? $strSQL2 = "SELECT DISTINCT testitem.* FROM drug_testitem_testmethod,testitem WHERE drug_testitem_testmethod.Drug_No = '".$_GET["DisID"]."' AND drug_testitem_testmethod.TestItem_No=testitem.Testitem_No AND drug_testitem_testmethod.Flag = '1'"; $objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]"); ?> <? while($objResult2 = mysql_fetch_array($objQuery2)) { ?> <tr> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"><?=$objResult2["TestItem_No"];?></div></td> <td><div align="center"><?=$objResult2["TestItem_Name"];?></div></td> </tr> <? $strSQL3 = "SELECT DISTINCT testmethod.* FROM drug_testitem_testmethod,testmethod,testitem WHERE drug_testitem_testmethod.Drug_No = '".$_GET["DisID"]."' AND drug_testitem_testmethod.TestMethod_No=testmethod.TestMethod_No AND drug_testitem_testmethod.TestItem_No=testitem.Testitem_No "; $objQuery3 = mysql_query($strSQL3) or die ("Error Query [".$strSQL3."]"); ?> <? while($objResult3 = mysql_fetch_array($objQuery3)) { ?> <tr> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"><?=$objResult3["TestMethod_No"];?></div></td> <td><div align="center"><?=$objResult3["TestMethod_Name"];?></div></td> </tr> <? } } } ?> </table> <? mysql_close($con_id); } ?>
<? if($_GET["ProID"] != "") { $strSQL = "SELECT * "; $strSQL .= "FROM drug as d"; $strSQL .= " WHERE (d.Drug_Status LIKE '".$_GET["ProID"]."' AND d.Drug_No LIKE '".$_GET["DisID"]."')"; $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); $D_Drug_Status=$objResult["Drug_Status"]; $D_Drug_Name=$objResult["Drug_Name"]; $D_Drug_No=$objResult["Drug_No"]; ?> <table width="800" border="1"> <tr> <th width="5%"> <div align="center">Drug No </div></th> <th width="10%"> <div align="center">Drug Name </div></th> <th width="5%"> <div align="center">Drug Status </div></th> <th width="5%"> <div align="center">Item No </div></th> <th width="40%"> <div align="center">Item Name </div></th> <th width="5%"> <div align="center">Method No </div></th> <th width="40%"> <div align="center">Method Name </div></th> <tr> <? while($objResult = mysql_fetch_array($objQuery)) { ?> <tr> <td><div align="center"><?=$objResult["Drug_No"];?></div></td> <td><div align="center"><?=$objResult["Drug_Name"];?></div></td> <td><div align="center"><?=$objResult["Drug_Status"];?></div></td> </tr> <? $strSQL2 = "SELECT DISTINCT testitem.* FROM drug_testitem_testmethod,testitem WHERE drug_testitem_testmethod.Drug_No = '".$_GET["DisID"]."' AND drug_testitem_testmethod.TestItem_No=testitem.Testitem_No AND drug_testitem_testmethod.Flag = '1' ORDER BY TestItem_Name"; $objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]"); ?> <? while($objResult2 = mysql_fetch_array($objQuery2)) { ?> <tr> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"><?=$objResult2["TestItem_No"];?></div></td> <td><div align="center"><?=$objResult2["TestItem_Name"];?></div></td> </tr> <? $strSQL3 = "SELECT DISTINCT testmethod.* FROM drug_testitem_testmethod,testmethod,testitem WHERE drug_testitem_testmethod.Drug_No = '".$_GET["DisID"]."' AND drug_testitem_testmethod.TestMethod_No=testmethod.TestMethod_No AND drug_testitem_testmethod.TestItem_No='".$objResult2["TestItem_No"]."' AND drug_testitem_testmethod.Flag = '1' "; $objQuery3 = mysql_query($strSQL3) or die ("Error Query [".$strSQL3."]"); ?> <? while($objResult3 = mysql_fetch_array($objQuery3)) { ?> <tr> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"><?=$objResult3["TestMethod_No"];?></div></td> <td><div align="center"><?=$objResult3["TestMethod_Name"];?></div></td> </tr> <? $strSQL4 = "SELECT DISTINCT drug_testmethod_limit.* FROM drug_testmethod_limit,testmethod WHERE drug_testmethod_limit.Drug_No = '".$_GET["DisID"]."' AND drug_testmethod_limit.TestMethod_No='".$objResult3["TestMethod_No"]."' "; $objQuery4 = mysql_query($strSQL4) or die ("Error Query [".$strSQL4."]"); ?> <? while($objResult4 = mysql_fetch_array($objQuery4)) { ?> <tr> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"></div></td> <td><div align="center"><?=$objResult4["Description"];?></div></td> </tr> <? } } } } ?> </table> <? mysql_close($con_id); } ?>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง