How to send an email on a specific date?

Question

PHP

Good day!

Please help.
There is a database table in which records are entered: -
name
- date of notification
- email for notification Thank you in advance!

Answer 1

Add another processed boolean field,

SELECT * FROM queue WHERE date < now() AND processed = false;

Before sending the letter, change processed to true.
Well, run this script once a day/hour/minute.