Need a script

[AvisSoft]

Hello,

I have a database in which i am entering dates in my own format i.e: dd-mm-yyyy instead of using unix timestamp. Anyways i want a ascript which would keep on checking :

if the date in db is coming after 10 days then it should send an email
if the date in db is coming after 7 days then it should send an email
and from the 7th day onwards it should keep on sending emails every day till the date is matched with real date.

Please let me know if i have explained this properly.

Thanks

[AvisSoft]

Hi,

Can anyone help me with this ?

Thanks

[visualAd]

What have you got so far? - I don't have the time to write you an entire script and by the looks of things it doesn't appear as if other people do either.

Have a look at this thread which shows a query which uses some of the MySql date/time functions to calculate the number of days until someones birthday. You can probably adapt this to your own script:

https://www.vbforums.com/showthread.php?t=333108

Have a go at coding it yourself and if you run into any problems just post here

[AvisSoft]

Hi,

LOL very correct that i should do something first, actually i tried but wa snot successfull with sql query that is why i posted here...but lookign at that thread yo gave i think it will work as the guy in that thread is also using the same date format like i am.

I will post again incase i face any problem

Thanks