Hi
I need the php code to represent this table like the report below it:
CREATE TABLE `events_schedule` (
`schedule_id` int(11) NOT NULL auto_increment,
`events_id` int(11) NOT NULL default '0',
`period_day` varchar(16) NOT NULL default '',
`period_time` varchar(16) default '00:00',
`seats` int(11) default '0',
`class_1_id` int(11) default NULL,
`class_2_id` int(11) default NULL,
`class_3_id` int(11) default NULL,
`class_4_id` int(11) default NULL,
`class_5_id` int(11) default NULL,
`class_sponsor_1_id` int(11) default NULL,
`class_sponsor_2_id` int(11) default NULL,
`class_sponsor_3_id` int(11) default NULL,
`class_sponsor_4_id` int(11) default NULL,
`class_sponsor_5_id` int(11) default NULL,
`class_teacher_1_id` varchar(64) default NULL,
`class_teacher_2_id` varchar(64) default NULL,
`class_teacher_3_id` varchar(64) default NULL,
`class_teacher_4_id` varchar(64) default NULL,
`class_teacher_5_id` varchar(64) default NULL,
`schedule_date_day` datetime NOT NULL default '0000-00-00 00:00:00',
`schedule_date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`schedule_last_modified` datetime default NULL,
`schedule_date_available` datetime default NULL,
`schedule_status` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`schedule_id`),
KEY `idx_schedule_date_added` (`schedule_date_added`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;
The output is like this:
period_day CLASSES SPONSOR TEACHER SEATS LEFT SELECT
period_time class_?_id class_sponsor_?_id class_teacher_?_id seats
And the print out should look like this:
MONDAY CLASSES SPONSOR TEACHER SEATS LEFT SELECT
18:00 - First Aid ICI Mr Smith 20 [] <-checkbox
.
20:00 - PC Intro Dell Mr Data 7 []
TUESDAY CLASSES SPONSOR TEACHER SEATS LEFT SELECT
15:00 - Car mech BP Miss Chang []
.
.
18:00 - First Aid ICI Mr Smith 20 []
WEDNESDAY CLASSES SPONSOR TEACHER SEATS LEFT SELECT
18:00 - First Aid ICI Mr Smith 20 []
etc to end of records
If you can do this as soon as possible, bid and the right price gets the job.
Thank you