Jump to content

Archived

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

oldschool

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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE `tbl_settings` (
  `varName` varchar(255) NOT NULL,
  `varValue` text NOT NULL,
  `varDesc` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- 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.

[img]http://dengate.amplifeyesolutions.com/example_grid.png[/img]

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.