school mailing system

I am developing a bulk email system to send messages to parents of the
children in the school I work at, using php and mysql. The database
holding the parents' email addresses and what yeargroup their child is in.

I would appreciate any input on the best method of tracking a pupil's
yeargroup as they move up through the school. For example, I would like a
field in each record to indicate what yeargroup they are currently a part
of and when the next academic year comes around there wouldn't be any
needs for an update.

Any suggestions for a best approach?

Regards,

Chris

On Sun, 20 Feb 2005 13:34:12 +0000, Chris Matchett wrote:

 > I am developing a bulk email system to send messages to parents of the
 > children in the school I work at, using php and mysql. The database
 > holding the parents' email addresses and what yeargroup their child is in.
 >
 > I would appreciate any input on the best method of tracking a pupil's
 > yeargroup as they move up through the school. For example, I would like a
 > field in each record to indicate what yeargroup they are currently a part
 > of and when the next academic year comes around there wouldn't be any
 > needs for an update.
 >
 > Any suggestions for a best approach?
 >
 > Regards,
 >
 > Chris

Apologies, should have cross-posted this message to alt.php.sql in
first place (doing so now).

Chris