I am updating my MySQL table with specific time. What actually happening is - payment status is unpaid and it will automatic cancel after 15 mins. but only specific payment status, who is older than 15 mins should be cancel.
i am trying to update mysql table entry only in specific time like 15 min.
$sql = "UPDATE payers SET payment_status='Cancel' WHERE
payment_status=unpaid >= NOW() - INTERVAL 15 MINUTE";
if(mysqli_query($conn, $sql)){
echo "Record was updated successfully.";
} else {
echo "ERROR: Could not able to execute $sql. "
. mysqli_error($conn);
}
mysqli_close($$conn);
payment_status need to update only when unpaid is older than 15 mins.
This SQL should work for you:
UPDATE payers
SET payment_status='Cancel'
WHERE payment_status='unpaid'
AND payment_time <= NOW() - INTERVAL 15 MINUTE
However, this has hidden problem: what if someone pays exactly after 15 min of order submission? They would have paid, but you wouldn't send them your goods.