Automatic Email

[cyprex]

Hey guys,

I have a site that will be somewhat like a classifieds website. Everything is stored in a mysql database table called 'Postings', including the poster's e-mail address ('Email') and the date ('PostDate') the item was posted.

I want to create code that will automatically e-mail the person 1 month after the posting was submitted with 2 links - 1 to renew the posting, and 1 to remove the posting. Obviously when the renew link is clicked I want to automatically reset the ('PostDate') field to the Current Date, and when the remove link is clicked I want the row to automatically delete.

Any suggestions as to how to do this? And where would I put the code to be execute??

Thanks

Curtis

 

[johnwm]

Hi and welcome to Tek-Tips. Start by carefully reading faq222-2244 which will help you understand how to get the best from the site. Then look for the forum dealing with the server-side language you are using. You can find forums on the site using the Search at the top of the page. Depending on your server OS you will need to run a cron job (or your OS equivalent) to trigger the action.

If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller