asked on

Set Alarm

Hello,

I am trying to build a system using PHP/MySAL.
This system can send an automatic notification (email) on a specific date stored into our DB without any humain interference.
At the end my system will look like Birthday Alarm or MSN Notifications...
Send a notification to user on a specific date stored before...

What is the best way to do it? and how?

Thank you

Dany Namroud

SOLUTION

cachedVB

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Promethyl

Store id, enabled, alarmed, date, time, owner, desc in the database.

Query it once a day or hour, depending on your needs.

Sounds pretty simple!

dnamroud

ASKER

Thank you cachedVB and Promethyl for your answers

cachedVB, your example worked only if I am running PHP/MySQL on Linux Server and i guess it's a good soultion...
What if i am using a Windows server (this is my case)

Promethyl, how can I run a query automatically on a basic schedule( once per day or per period)?

Thank you

Dany Namroud