archive in php| please help

[Bass_A]

Hi, im german and i don`t speak english very well so please excuse my bad english. Now to my problem I want to build a news site for my school and for this site i need a archive.
This archive should all entrys from a mysql Table older than e.g 3 weeks move to anothe table wich can be viewed in another phpsite with the name "Archiv"
can someone please help me how I've can do this ?
(maybe with some code)

[nemonoman]

You need a date or timestamp column in your news table:

Then

INSERT INTO archiv (YourColumn1, YourColumn2...etc.)
SELECT NewsColumn1, NewsColumn2, etc FROM news WHERE timestampColumn<(NOW()-INTERVAL 21 day)

Then
DELETE FROM news WHERE timestampColumn<(NOW()-INTERVAL 21 day)

You need to change YourColumn1, etc to the names you are using.

[Bass_A]

thanks this was what i needed