Hi

The case scenario is this;

a website allows people to book rooms on certain dates. I would like the website to email clients 7 days before their booking date to remind them that they have made this booking... how do i get my website to do this automatically?

Thanks

lworks

hello..

you just add 7 days to your user booked date by using DATEADD function in mysql...
and compare that date with CURDATE ,then if condition is ok,write mail function to remind them ...

Hi, thanks for getting back to me - i understand the maths of working out the date, but how do i get my website to do this, without any specific prompt (button clicks etc) from me...

Thanks

Hi,

Schedule you page in window schedular and it will run automatically.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.