Archiving?

[7724]

Hi Guys,

I have my content managed system with news and hundreds of stories in it with the table structure below.

newsid int(4) No auto_increment
name varchar(255) No
headline varchar(255) No
storydate date No
byline varchar(255) No
opening blob BINARY No
body blob BINARY No
picture varchar(255) No
caption varchar(255) No

Now I want to create an archive each month to put these stories in. So I have a page with links which puts these in monthly order ie:

January 2005 (25 Stories)
Febuary 2005 (26 Stories)
March 2005 (20 Stories)

Then when one of the above is clicked on it shows all the story headlines from that month with the date each story was published and a link through to the actual story.

But how do I go about this? Like I say my stories all are in one news table. Can anyone point me in the right direction? or maybe a archive tutorial (I can't find one googleing!) Can this be done automatically?

Thanks

Chris

[saraadmin]

Now I want to create an archive each month to put these stories in.

Do you mean that you need to transfer the stories from one database/table to another?

If not, then can't you just use queries like:

SELECT count(news_id) FROM stories WHERE storydate LIKE "Januray 2005";

or

SELECT storydate, count(news_id) FROM stories GROUP BY storydate;

to make the archive front page links.

And then queries like this:

SELECT * FROM stories WHERE storydate LIKE "Januray 2005";

for each month/year archive page?