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 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? 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 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 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???? 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
Archived
This topic is now archived and is closed to further replies.