Organizing news by month and year?

Anon

I have news that is stored in a mysql table.

For old archived news how would I go about organizing it in months and years. For example someone could click December 2000 and it would show all the news archived from that month. Also it would automatically add the new month to the archive page when news has been archived for that month.

I am guessing you do a select statement using a timestamp (I have timestamp(14) as one column) to organize them.

Thanks,
Andrew

finger

i dont think that i understand your problem
correctly. if you just want the news to have
a creationtime: just create an date-field in
the news-table. afterwards you can select
all news where the date equals current date.

regards
finger

sepodati

Correct, it is just a matter of how you make your SELECT statement.

SELECT * FROM news_table WHERE YEAR(timestamp_column) = 2000 AND MONTH(timestamp_column) = 12;

for everything from 12-2000.

Or, if anything over six months is considered archived, then you can do this:

SELECT * FROM news_table WHERE timestamp_colum < NOW() - INTERVAL 6 MONTH;

Adapt to your needs...

---John Holmes...

Anon

Thanks a lot!

Anon

I got it working!

Check it out here:
http://www.pbreview.com/archive.php3