faqts : Computers : Programming : Languages : PHP : Database Backed Sites : MySQL

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

10 of 16 people (63%) answered Yes
Recently 4 of 7 people (57%) answered Yes

Entry

how do I write a script to delete database entries over x weeks old?

Sep 15th, 2000 16:20
Narendra Jain, steven melendez,


You have to convert n weeks into days first and then use a sql query to
delete rows from the database.
<? $l_days=n*7
   $del_date=Date() - $l_days days
   $mysql_query = ($mydb, "delete from trans_table where entry_date <
$del_date")
?>