[SOLVED] delete database entry after 30 days?

[marksie1988]

using php and mysql how can i tell the my website to move any entry older than 30 days to a different table and then delete it below i have some script i did try but this doesnt work (im using unix timestamp incase that changes anything)

 

mysql_query("
INSERT INTO newsarchive (id, postdate, title, newstext)
SELECT id, postdate, title, newstext FROM news WHERE postdate < DATE_SUB(curdate(), INTERVAL 30 DAY)");

mysql_query("DELETE FROM news WHERE postdate < DATE_SUB(curdate(), INTERVAL 30 DAY)");

mysql_close($link); //clean up

[Barand]

Try

 

either

 

... WHERE FROM_UNIXTIME(postdate) < DATE_SUB(curdate(), INTERVAL 30 DAY)

 

or

 

... WHERE postdate < UNIX_TIMESTAMP(DATE_SUB(curdate(), INTERVAL 30 DAY))

[marksie1988]

tried both of these neither work

 

anything else?

[AndyB]

Define "neither of those work".  Any errors? When you echo either of those query strings what do they contain?

[marksie1988]

i get nothing no errors or anything and how do i echo the querys :S sorry ive just never done that