News Archiving??

[stublackett]

Hi,

 

I've got a Database setup that has data inserted into it when a user inserts news

 

What I'm looking to do is archive the news items by the four seasons : Autumn, Winter, Spring & Summer

 

My Database is a simple table setup as follows :

id

title

description

 

Thats fine for the time being, But I'd like to archive the news by season

 

My INSERT News PHP Code is as follows (I'm thinking of INSERTING a date field which you can do queries on)

$sql = "INSERT INTO news(title,description) values ('$title','$description')";