newphpcoder Posted April 13, 2012 Share Posted April 13, 2012 Hi... I have form of uploading data to the database, but I need to delete data after 1 month. how does it possibe. here is my query of insert data to the database: $sql = "INSERT INTO sales_order (ProductType,WorkOrder,POIssueDate,SalesMonth) VALUES ('$ProductType','$WorkOrder','$POIssueDate','$SalesMonth') ON DUPLICATE KEY UPDATE ProductType = '$ProductType', WorkOrder = '$WorkOrder', POIssueDate = '$POIssueDate', SalesMonth = '$SalesMonth'" or die(mysql_error()); mysql_query($sql, $con); Should I need to add fields for date upload? Thank you Link to comment https://forums.phpfreaks.com/topic/260849-delete-data-after-1-month/ Share on other sites More sharing options...
Muddy_Funster Posted April 13, 2012 Share Posted April 13, 2012 It's highly irregular to actualy delete information from a database that relates to any commercial process. Especialy after only 1 month. Common practice is to archive it after either a year or a quarter, depending on the environment. Your sure you want to delete? Link to comment https://forums.phpfreaks.com/topic/260849-delete-data-after-1-month/#findComment-1336945 Share on other sites More sharing options...
fenway Posted April 15, 2012 Share Posted April 15, 2012 I've told you not to double-post before -- last warning. Link to comment https://forums.phpfreaks.com/topic/260849-delete-data-after-1-month/#findComment-1337631 Share on other sites More sharing options...
Recommended Posts