0

I need to get the list of diagnosed disease of the patient by choosing his name in the combo box,how can I do that? This is my code.

<select name="pname" class="textfields" id="model"  style="width:180px;"    onchange="getVal1();">
    <option id="0" >--Select Patient Name--</option>
     <?php
        $con=mysqli_connect("localhost","root","","dbnpatient");
            if (mysqli_connect_errno()){
              echo "Failed to connect to MySQL: " . mysqli_connect_error();
            }
        $pnum=$_GET['pnum'];
        $query = mysqli_query($con, "SELECT * FROM tblnpatient");
        while($row = mysqli_fetch_array($query)){
            $pnum = $row['pnum'];
            $pname = $row['pname'];
            $addr = $row['addr'];
            $complaints = $row['complaints'];
    ?>

    <option id="<?php echo $pnum; ?>" data-pnum="<?php echo $pnum; ?>" data-addr="      <?php echo $addr; ?>" data-    complaints="<?php echo $complaints; ?>"  value="<?php echo $pname; ?>"><?php echo $pname; ?></option>
    <?php } ?>




    //this is my code for filtering the table and having trouble because the $pname is undefined

    <?php
            $con=mysqli_connect("localhost","root","","dbnpatient");
            if (mysqli_connect_errno()){
              echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
             $pname=$_GET['pname'];
            $result = mysqli_query($con,"SELECT * FROM tbldiagnosis
            WHERE pname='$pname'");

            while($row = mysqli_fetch_array($result)) {
            echo '<tr class="record">';
            echo '<td>'.$row['diagnosis'].'</td>';
}
?>

Edited by eahdbz12

3
Contributors
3
Replies
12
Views
3 Years
Discussion Span
Last Post by thirsty.soul
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.