lovely Posted February 26, 2007 Share Posted February 26, 2007 Hi all, How to automatically trigger an event. I have a field name "Iv_Date" in the DB, so after one week from the invoice date,it has to be automatically archived. Thank u Link to comment https://forums.phpfreaks.com/topic/40128-help-needed/ Share on other sites More sharing options...
suzzane2020 Posted February 26, 2007 Share Posted February 26, 2007 u can try this write a code tht checks the diff between te current date and the invoice date. n when the diff is 7 the query to archive is executed so put the query in the if condition. Link to comment https://forums.phpfreaks.com/topic/40128-help-needed/#findComment-194150 Share on other sites More sharing options...
lovely Posted February 26, 2007 Author Share Posted February 26, 2007 u can try this write a code tht checks the diff between te current date and the invoice date. n when the diff is 7 the query to archive is executed so put the query in the if condition. The problem is i want to do automatically without the user visiting the page Link to comment https://forums.phpfreaks.com/topic/40128-help-needed/#findComment-194178 Share on other sites More sharing options...
Hooker Posted February 26, 2007 Share Posted February 26, 2007 Look into Cronjobs would be my suggestion Link to comment https://forums.phpfreaks.com/topic/40128-help-needed/#findComment-194185 Share on other sites More sharing options...
heckenschutze Posted February 26, 2007 Share Posted February 26, 2007 cron tabs/jobs on * nix and scheduled tasks on Windoze... Link to comment https://forums.phpfreaks.com/topic/40128-help-needed/#findComment-194187 Share on other sites More sharing options...
lovely Posted February 26, 2007 Author Share Posted February 26, 2007 Thank You all Link to comment https://forums.phpfreaks.com/topic/40128-help-needed/#findComment-194190 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.