Jump to content

Attendance Register


oldschool

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  ???
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.