Jump to content


Photo

Attendance Register


  • Please log in to reply
No replies to this topic

#1 oldschool

oldschool
  • Members
  • PipPip
  • Member
  • 15 posts

Posted 08 October 2006 - 12:55 PM

SQL Resources

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', '');

Background Information

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.

The Problem

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

Posted Image

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users