2. PHPRunner General questions
  3. Moving records to different table.
This topic is locked

Moving records to different table.

 		11/29/2016 2:26:35 PM
PHPRunner General questions
Z
 zeth385 author

Hello guys!
I have this database that contains two important fields: "Status" and "Status Due Date". What I need is to move the records to "History" when the status is set manually to "Inactive". But we also have de "Status Due Date". What I need is that the record is moved to the "History" table when the due date arrives.
I need your help with this... Thanks in advance!
Sergey Kornilov admin 11/29/2016

Are you talking about moving data to archive table automatically, without user interaction?
Z
 		zeth385 author 11/29/2016



Are you talking about moving data to archive table automatically, without user interaction?


That's correct!
Sergey Kornilov admin 11/30/2016

You cannot use PHPRunner for this purpose. If you want something automatic that needs to be a standalone PHP script/page that runs on timely fashion using an external job scheduler like cron.
We have MassMailer template docs that explain how to setup a PHP page to run once a day or once an hour:

http://xlinesoft.com/massmailer
You still need to write the script itself and test it before scheduling it. Contact support directly if you need help doing that.