You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
$query="SELECT * FROM doc_report WHERE indicator = 0 AND User_Id='$name'";
$result = mysqli_query($con,$query);
while($a=mysqli_fetch_assoc($result)){
$aadhar=$a['Aadhar_id'];
$test=$a['Test_Name'];
$query="INSERT INTO sample_to_lab(User_id,date,Aadhar_id,Lab_id) SELECT '$name',CURDATE(),'$aadhar',lab.Lab_id FROM tests,lab WHERE tests.lab_Id = lab.lab_id AND Test_Name='$test'";
mysqli_query($con,$query);
}
$query = "UPDATE doc_report SET indicator = 1 WHERE indicator = 0 AND User_Id='$name'";