I have been asked to create a small student mamangement system for a local club.

Now I have one problem. The attendance register, I can of course commit to the database on which days a student attends (currently this local club only runs tuesdays and thursday nights).

But it's the reporting, showing when a student has been absent,

Kind of like a calender display,

attendance table:

date (unknown)
attended (LONTEXT CSV of attending student ID's)
recid (unique row id AUTO_INC)

populated with several rows with dates in place, then these are updated with attendance records.

Now I don't want to go down this route as it requires inserting data before it is needed.

Can some one suggest a better approach?