0) { $patq = mysql_query("SELECT * FROM patient WHERE patient_id = '$patient_id'") or die(mysql_error()); if (mysql_num_rows($patq) > 0) { $is_patient = true; $patr = mysql_fetch_array($patq); // Load ailments of the patient $pal = array(); $palq = mysql_query("SELECT * FROM patient_ailment, ailment WHERE patient_id = '$patient_id' AND patient_ailment.ailment_id = ailment.ailment_id") or die(mysql_error()); while ($palr = mysql_fetch_array($palq)) $pal[] = $palr; } } // Load RA Procedures $rapq = mysql_query("SELECT * FROM ra_procedure WHERE log_id = '$log_id'") or die(mysql_error()); $num_ra = mysql_num_rows($rapq); $rap = array(); while ($rapr = mysql_fetch_array($rapq)) $rap[$rapr['ra_id']] = $rapr; } } ?>
Note: