undertaker16 Posted February 5, 2007 Share Posted February 5, 2007 I need help... I am trying to create a php script that will check the date that a record was created and if a config var. is set to say 30, it will set the record's status to archived or something. Please help if you can.. Josh Quote Link to comment https://forums.phpfreaks.com/topic/37099-auto-archiving-a-mysql-record-with-php/ Share on other sites More sharing options...
fenway Posted February 5, 2007 Share Posted February 5, 2007 Huh? Quote Link to comment https://forums.phpfreaks.com/topic/37099-auto-archiving-a-mysql-record-with-php/#findComment-177208 Share on other sites More sharing options...
undertaker16 Posted February 5, 2007 Author Share Posted February 5, 2007 I need someway to update a record to set the status to "archived" after it checks to see if it is older than a certian amount of days by checking say a column "creation_date". thanks Quote Link to comment https://forums.phpfreaks.com/topic/37099-auto-archiving-a-mysql-record-with-php/#findComment-177335 Share on other sites More sharing options...
paul2463 Posted February 5, 2007 Share Posted February 5, 2007 you need to create a function that checks all the entries in the database and sets a flag to archived if that entry is greater than 30 days old then you will need to set up a CRON job to run it once a day Quote Link to comment https://forums.phpfreaks.com/topic/37099-auto-archiving-a-mysql-record-with-php/#findComment-177338 Share on other sites More sharing options...
undertaker16 Posted February 5, 2007 Author Share Posted February 5, 2007 I know that but how???? Quote Link to comment https://forums.phpfreaks.com/topic/37099-auto-archiving-a-mysql-record-with-php/#findComment-177496 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.