Jump to content


This topic is now archived and is closed to further replies.


Attendance Register

Recommended Posts

[u][b]SQL Resources[/b][/u]

[code]CREATE TABLE `tbl_attendance` (
  `attn_enrol_id` int(11) NOT NULL,
  `attn_id` int(11) NOT NULL auto_increment,
  `attn_w1` tinyint(1) NOT NULL,
  `attn_w2` tinyint(1) NOT NULL,
  `attn_w3` tinyint(1) NOT NULL,
  PRIMARY KEY  (`attn_id`)

CREATE TABLE `tbl_settings` (
  `varName` varchar(255) NOT NULL,
  `varValue` text NOT NULL,
  `varDesc` text NOT NULL

-- Dump week settings. *other settings omitted*

INSERT INTO `tbl_settings` (`varName`, `varValue`, `varDesc`) VALUES ('num_weeks', '3', ''),
('attn_w1', '2006-09-25', ''),
('attn_w2', '2006-10-02', ''),
('attn_w3', '2006-10-09', '');[/code]

[b][u]Background Information[/u][/b]

The number of week is completly dynamic. It can be changed on the fly by the user. The 'week' columns that are presented on the register need to be produced on the fly.

[b][u]The Problem[/u][/b]

I having difficuly producing the grid. The graphic below should help to understand.


I can't work out in my mind or on paper how to assign a appropiate name to each 1 or 0 (these will be checkboxes).

Any tips/advice would be great

Feel free to contact me via IM or Email

:: danieldengate@amplifeye.com

thanks guys
Dan  ???

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.