crush899
Posts: 22
|
Posted: 09/19/2011, 7:54 PM |
|
Hi I need some help crafting code to display records that are due in 10 days. I'd like the code to generate an email notification to the record holder.
I have an events table and user table
does anyone have a solution?
Thanks
|
|
|
mamboBROWN
Posts: 1713
|
Posted: 10/02/2011, 1:02 PM |
|
crush899,
Have you resolved this yet or do you still need assistance?
|
|
|
benjohn
Posts: 30
|
Posted: 10/12/2011, 4:53 PM |
|
hi there crush899,
Good Day!
assuming you are using mysql as your back end database
try the sql:
select * from event where recordtimestamp >= NOW() - DATE_ADD(CURDATE(), INTERVAL -10 DAY);
which would give you the users. then through the loop of this sql statement you could email the users. let me know if you need help on the exact codes. hope this helps... all the best!
pal,
Benjohn
_________________
~=~=~=~=~=~=~=~=~=~=~=
get it done. make it happen.
~=~=~=~=~=~=~=~=~=~=~= |
|
|
crush899
Posts: 22
|
Posted: 01/02/2012, 5:49 PM |
|
Hi Ben,
I've tried everything and keep hitting a wall. Could you giv e me some assistance?
Ted
|
|
|
girish_327
Posts: 108
|
Posted: 01/13/2012, 3:13 AM |
|
_________________
Girish Baraskar
Web Designer/Developer
http://www.agnisdesigners.com
http://www.eindianpaintings.com
http://www.realestatekolhapur.com |
|
|
|