oldschool Posted October 8, 2006 Share Posted October 8, 2006 [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 greatFeel free to contact me via IM or Email:: danieldengate@amplifeye.comthanks guysDan ??? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.