if (mysqli_num_rows($resPart4) > 0) {
while ($rowPart4 = mysqli_fetch_array($resPart4)) {
$suspected = $rowPart4['suspected'];
if ($suspected == 1) {
$suspected = "Suspected";
} else {
if ($suspected == 2) {
$suspected = "Interaction";
} else {
if ($suspected == 3) {
$suspected = "Concomitant";
}
}
}
$actvIngredient = $rowPart4['actvIngredient'];
$actionTaken = getDrugActionByValue($con, $rowPart4['actionTaken']);
$subsided = $rowPart4['subsided'];
if ($subsided == 1) {
$subsided = "Yes";
} else {
if ($subsided == 2) {
$subsided = "No";
} else {
if ($subsided == 3) {
$subsided = "Unknown";
} else {
if ($subsided == 4) {
$subsided = "Not Applicable";
}
}
}
$allergyStat = "Yes";
} else {
if ($allergyStat == 2) {
$allergyStat = "No";
} else {
if ($allergyStat == 3) {
$allergyStat = "Unknown";
} else {
$allergyStat = "";
}
}
}
$Adr_rctFirstTime = $row2['Adr_rctFirstTime'];
$Adr_rctFirstTimeUnit = getAgeUnitByValue($con, $row2['Adr_rctFirstTimeUnit']);
$AdrTerminology = $row2['AdrTerminology'];
$drugAction = getDrugActionByValue($con, $row2['drugAction']);
$subsided = getSubsidedByValue($row2['subsided']);
$reappear = getSubsidedByValue($row2['reappear']);
$Adr_outcome = getOutcomeByValue($con, $row2['Adr_outcome']);
$history = $row2['history'];
$lab_data = $row2['lab_data'];
$report_comment = $row2['report_comment'];
if ($cs) {
$resTable .= "<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td rowspan='{$numrow_res2}'> {$c1} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td rowspan='{$numrow_res2}'> {$actvIngredient} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td rowspan='{$numrow_res2}'> {$product_name} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$route} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$Adrno} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$age} {$age_unit} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$allergyStat} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$Adr_rctFirstTime} {$Adr_rctFirstTimeUnit} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$AdrTerminology} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$drugAction} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$subsided} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$reappear} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$Adr_outcome} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$history} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$lab_data} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$report_comment}</td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>";
} else {
$resTable .= "<tr/>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$route} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$Adrno} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$age} {$age_unit}</td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$allergyStat} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$Adr_rctFirstTime} {$Adr_rctFirstTimeUnit}</td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$AdrTerminology} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$drugAction} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$subsided} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$reappear} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$Adr_outcome} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$history} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$lab_data} </td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<td> {$report_comment}</td>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t</tr>";
}
$cs = false;
}
}
} else {