Storage of news articles

[liammc87]

I have a task and I'm unsure how to approach it.

 

I have a database (MySQL) which stores news articles - just the general subject, content etc. The date is set with a timestamp.

 

What I want to do is sort of "Archive" my news to months. So I have one page which shows every article from the current month - and a link to every other month with an article. Then when this link is clicked it shows the news from that month.

 

I cannot figure out how to approach this - any help is appreciated!

 

Thanks,

 

Liam.

[MadTechie]

Add a field for the month set it to 1-12 (for each month)

 

then on the page that displays the details from the database add

 

$theDate= getdate();

"SELECT * from table WHERE month = ".$theDate['mon'];