<?php
include 'connection.php';
    $query = "SELECT patient.patient_id, patient.fname, patient.mname, patient.lname, diagnosis.diag, diagnosis.symptoms, diagnosis.treatment,
    diagnosis.dremarks, diagnosis.dod
                    FROM patient
                    LEFT JOIN diagnosis
                    ON patient.patient_id=diagnosis.patient_id
                    WHERE patient.patient_id = $_GET[id]";

$result = mysql_query($query);
while($person = mysql_fetch_array($result)) {
echo "<tr class='searchadds'>";
echo "<td align='center' height='30'><font color='#fff' size='2'>" . $person['symptoms'] . "</td>";
echo "<td align='center' height='30'><font color='#fff' size='2'>" . $person['treatment'] . "</td>";
echo "<td align='center' height='30'><font color='#fff' size='2'>" . $person['dremarks'] . "</td>";
echo "<td align='center' height='30'><font color='#fff' size='2'>" . $person['dod'] . "</td>";
echo "<td  height='30' class='menu'><center><a href=\"#\" onClick=\"MyWindow=window.open('ddiagnosisadd.php?id=" . $person['patient_id'] . "','MyWindow','toolbar=no,location=center,directories=no,status=no, menubar=no,scrollbars=no,resizable=0,width=300,height=500,left=2px,top=10,right=2px,bottom=10px'); return false;\">";
echo "<center><img src='img/update.png'><font color='#fff'>&nbsp;Add Record</center></td>";
echo "</a></center>";
echo "</tr>";
}
echo "</table>";
echo "<br>";
?>