Advertisement
Guest User

Untitled

a guest
Feb 25th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.25 KB | None | 0 0
  1. $fnamechk1 = @mysql_query("SELECT * FROM dailymed WHERE level = 'discharge' and fname='$fname' and ipn='$ipn'");
  2. if(mysql_num_rows($fnamechk1) !== 0) {
  3. mysql_query("UPDATE dailymed SET level='discharge1' Where fname='$fname' AND ipn='$ipn' and level='inpatient'");
  4. echo "<script>alert('DISCHARGE1')</script>";
  5. }
  6.  
  7.  
  8. $fnamechk2 = @mysql_query("SELECT * FROM dailymed WHERE level = 'discharge1' and fname='$fname' and ipn='$ipn'");
  9. if(mysql_num_rows($fnamechk2) !== 0) {
  10. mysql_query("UPDATE dailymed SET level='discharge2' Where fname='$fname' AND ipn='$ipn' and level='inpatient'");
  11. echo "<script>alert('DISCHARGE2')</script>";
  12. }
  13.  
  14.  
  15. $fnamechk3 = @mysql_query("SELECT * FROM dailymed WHERE level = 'discharge2' and fname='$fname' and ipn='$ipn'");
  16. if(mysql_num_rows($fnamechk3) !== 0) {
  17. mysql_query("UPDATE dailymed SET level='discharge3' Where fname='$fname' AND ipn='$ipn' and level='inpatient'");
  18. echo "<script>alert('DISCHARGE3')</script>";
  19. }
  20.  
  21.  
  22. $fnamechk4 = @mysql_query("SELECT * FROM dailymed WHERE level = 'discharge3' and fname='$fname' and ipn='$ipn'");
  23. if(mysql_num_rows($fnamechk4) !== 0) {
  24. mysql_query("UPDATE dailymed SET level='discharge4' Where fname='$fname' AND ipn='$ipn' and level='inpatient'");
  25. echo "<script>alert('DISCHARGE4')</script>";
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement