archiving by timestamp

[JKG]

any one know of any scripts to archive news items by timestamp?

google searches just show tonnes of news archives.. not what i want!

 

obviously using php, all news items have a timestamp, how would i go about this? very open ended question but ANY help would really be appreciated.

 

Thanks!

[WebStyles]

are you talking about files (i.e. scans of news clippings in jpeg or something) or articles stored in a database with a timestamp?

[JKG]

Hi WebStyles thanks for the reply.

 

I am talking about news items stored in a database with a timestamp.

 

Thanks.

[WebStyles]

and by 'archiving' do you want to simple display them grouped by month, or actually move them to another table?

[JKG]

just aesthetically. group by month automatically. thanks again.

[WebStyles]

then you can use something like:

EXTRACT (MONTH from `date`) in your mysql query.

check out other options, depending on the type of field you're using (INT with unix timestamp, or mysql timestamp) here: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_extract

 

hope this helps

[JKG]

thanks for this. in the end i used

 

SELECT *, MONTH(`timestamp`) as `Month`, YEAR(`timestamp`) as `Year` FROM `news` order by timestamp desc

 

but your suggestion got me on the right path.

 

much appreciated.