Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $fnamechk1 = @mysql_query("SELECT * FROM dailymed WHERE level = 'discharge' and fname='$fname' and ipn='$ipn'");
- if(mysql_num_rows($fnamechk1) !== 0) {
- mysql_query("UPDATE dailymed SET level='discharge1' Where fname='$fname' AND ipn='$ipn' and level='inpatient'");
- echo "<script>alert('DISCHARGE1')</script>";
- }
- $fnamechk2 = @mysql_query("SELECT * FROM dailymed WHERE level = 'discharge1' and fname='$fname' and ipn='$ipn'");
- if(mysql_num_rows($fnamechk2) !== 0) {
- mysql_query("UPDATE dailymed SET level='discharge2' Where fname='$fname' AND ipn='$ipn' and level='inpatient'");
- echo "<script>alert('DISCHARGE2')</script>";
- }
- $fnamechk3 = @mysql_query("SELECT * FROM dailymed WHERE level = 'discharge2' and fname='$fname' and ipn='$ipn'");
- if(mysql_num_rows($fnamechk3) !== 0) {
- mysql_query("UPDATE dailymed SET level='discharge3' Where fname='$fname' AND ipn='$ipn' and level='inpatient'");
- echo "<script>alert('DISCHARGE3')</script>";
- }
- $fnamechk4 = @mysql_query("SELECT * FROM dailymed WHERE level = 'discharge3' and fname='$fname' and ipn='$ipn'");
- if(mysql_num_rows($fnamechk4) !== 0) {
- mysql_query("UPDATE dailymed SET level='discharge4' Where fname='$fname' AND ipn='$ipn' and level='inpatient'");
- echo "<script>alert('DISCHARGE4')</script>";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement