$due_date) { $penalty = round((float)(strtotime($date_returned) - strtotime($due_date)) / (60 * 60 *24) * ($penalty_amount['penalty_amount'])); } elseif ($date_returned < $due_date) { $penalty = 'No Penalty'; } else { $penalty = 'No Penalty'; } $id=$_GET['return_temporary_id']; mysqli_query($conn,"delete from return_temporary where return_temporary_id = '$id' ")or die(mysqli_error()); mysqli_query ($conn,"UPDATE borrow_book SET borrowed_status = 'returned', date_returned = '$date_returned_now', book_penalty = '$penalty' WHERE borrow_book_id= '$borrow_book_id' and user_id = '$user_id' and book_id = '$book_id' ") or die (mysqli_error()); mysqli_query ($conn,"INSERT INTO return_book (user_id, book_id, date_borrowed, due_date, date_returned, book_penalty) values ('$user_id', '$book_id', '$date_borrowed', '$due_date', '$date_returned', '$penalty')") or die (mysqli_error()); ?>