'.$username.''; // } // } function display_specs() { global $con; $query="select distinct(spec) from doctb"; $result=mysqli_query($con,$query); while($row=mysqli_fetch_array($result)) { $spec=$row['spec']; echo ''; } } function display_docs() { global $con; $query = "select * from doctb"; $result = mysqli_query($con,$query); while( $row = mysqli_fetch_array($result) ) { $username = $row['username']; $price = $row['docFees']; $spec = $row['spec']; echo ''; } } // function display_specs() { // global $con; // $query = "select distinct(spec) from doctb"; // $result = mysqli_query($con,$query); // while($row = mysqli_fetch_array($result)) // { // $spec = $row['spec']; // $username = $row['username']; // echo ''; // } // } if(isset($_POST['doc_sub'])) { $username=$_POST['username']; $query="insert into doctb(username)values('$username')"; $result=mysqli_query($con,$query); if($result) header("Location:adddoc.php"); } ?>