while ($rowPart3 = mysqli_fetch_array($resPart3)) { $suspected = $rowPart3['suspected']; if ($suspected == 1) { $suspected = "Suspected"; } else { if ($suspected == 2) { $suspected = "Interaction"; } else { if ($suspected == 3) { $suspected = "Concomitant"; } } } $actvIngredient = $rowPart3['actvIngredient']; $product_name = $rowPart3['product_name']; $route = getRouteByValue($con, $rowPart3['route']); $dosage = $rowPart3['dosage']; $dosageUnit = getDoseUnitByValue($con, $rowPart3['dosageUnit']); $doseInterval = $rowPart3['doseInterval']; $indication = $rowPart3['indication']; $therapy_start = dateChecker($rowPart3['therapy_start']); $therapy_stop = dateChecker($rowPart3['therapy_stop']); $part3Table .= "<tr> <td>{$suspected}</td> <td>{$actvIngredient}</td> <td>{$product_name}</td> <td> {$route} </td> <td>{$dosage} {$dosageUnit}</td> <td>{$doseInterval}</td> <td>{$indication}</td> <td>{$therapy_start} - {$therapy_stop}</td> </tr>"; } } else { $part3Table .= "<tr> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr>"; } $part3Table .= "</table>"; } $sqlPart4 = "SELECT DISTINCT adrug.suspected, adrug.actvIngredient, adrug.actionTaken, adrug.subsided, adrug.reappear, adetail.AdrTerminology, adrug.relatedness\n\t\t\t\t\t\t\t\t\tFROM adrdata adata, adrdetail adetail, adr_druglist adrug\n\t\t\t\t\t\t\t\t\tWHERE adata.adrFormID = adetail.adrFormID\n\t\t\t\t\t\t\t\t\tAND adata.adrFormID = adrug.adrFormID\n\t\t\t\t\t\t\t\t\tAND adrug.adrdetailID = adetail.adrDetailID\n\t\t\t\t\t\t\t\t\tAND adata.adrFormID = '{$fID}'"; $resPart4 = mysqli_query($con, $sqlPart4);
if ($res1) { if (mysqli_num_rows($res1) > 0) { $c1 = 1; $resTable = "\n\t\t\t\t\t\t\t\t\t\t\t\t\t<table class='table table-bordered table-condensed' border='1'>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> No. </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Active Ingredient </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Product Name </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Route </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th width='10%'> Report No. </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th width='8%'> Age </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Allergy Status </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th width='8%'> Onset </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Reaction Terminology </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Action Taken </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Dechallenge </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Rechallenge </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Outcome </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Relevant Medical History </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Relevant Lab Data </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<th> Report Comments </th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>"; while ($row1 = mysqli_fetch_array($res1)) { $actvIngredient = trim($row1['actvIngredient']); $product_name = trim($row1['product_name']); // echo "<br/> #$actvIngredient# - #$product_name# <br/>"; $sql2 = "SELECT DISTINCT adrug.route, adata.Adrno, adata.age, adata.age_unit, adata.allergyStat, adetail.Adr_rctFirstTime, adetail.Adr_rctFirstTimeUnit, adetail.AdrTerminology, adrug.drugAction, adrug.subsided, adrug.reappear, adetail.Adr_outcome, adata.history, adata.lab_data, adata.report_comment\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM adrdata adata, adr_druglist adrug, adrdetail adetail\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE adata.adrFormID = adrug.adrFormID\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adata.adrFormID = adetail.adrFormID\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.adrdetailID = adetail.adrDetailID\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND (adrug.suspected = '1' OR adrug.suspected = '2')\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adata.`status` = 'MM'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.relatedness = '{$relatedness}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adata.Madracno = '{$madracno}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.Pharmacological = '{$Pharmacological}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.actvIngredient = '{$actvIngredient}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND adrug.product_name = '{$product_name}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY adata.Adrno, adetail.AdrTerminology"; $res2 = mysqli_query($con, $sql2); if ($res2) { $numrow_res2 = mysqli_num_rows($res2); if (mysqli_num_rows($res2) > 0) { $cs = true; while ($row2 = mysqli_fetch_array($res2)) { $route = getRouteByValue($con, $row2['route']); $Adrno = $row2['Adrno']; // echo "<br/>$Adrno"; $age = $row2['age']; if ($age == "NULL") { $age = ""; } $age_unit = getAgeUnitByValue($con, $row2['age_unit']); $allergyStat = $row2['allergyStat']; if ($allergyStat == 1) { $allergyStat = "Yes"; } else { if ($allergyStat == 2) { $allergyStat = "No"; } else { if ($allergyStat == 3) {