?> </td> <td><?php echo $row1['time_slot_time']; ?> </td> <td> <?php $patient_id_n_pres = $obj_nurse->get_all_patient_id_n_prescription($doctor_id, $current_date); $patient_id_n_pres_array = array(); while ($row2 = mysql_fetch_assoc($patient_id_n_pres)) { $patient_id_n_pres_array[] = $row2['patient_id']; } if (in_array($row1['patient_id'], $patient_id_n_pres_array)) { $prescription_nurse_id_doctor_array = array(); $prescription_nurse_id_nurse = $obj_nurse->get_prescription_nurse_id_nurse($doctor_id, $row1['patient_id'], $result['nurse_id'], $current_date); $prescription_nurse_id_doctor = $obj_doctor->get_prescription_nurse_id_doctor(); while ($row3 = mysql_fetch_assoc($prescription_nurse_id_doctor)) { $prescription_nurse_id_doctor_array[] = $row3['prescription_nurse_id']; } if (in_array($prescription_nurse_id_nurse['prescription_nurse_id'], $prescription_nurse_id_doctor_array)) { echo '<a href="?page=view_prescription&pnid=' . $prescription_nurse_id_nurse['prescription_nurse_id'] . '"><b style="color: #000">View Prescription</b></a>'; } else { echo '<b style="color: #006600">View Prescription</b>'; } } else { ?> <b style="color: #ff0000">Make Prescription</b> <a href="?page=add_prescription_p&id=<?php echo $row1['patient_id']; ?>