database table listing

Închis Postat la Jul 6, 2004 S-au achitat serviciile după ce au fost prestate
Închis S-au achitat serviciile după ce au fost prestate

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

PHP

ID Proiect: #2992

Detalii despre proiect

3 propuneri Proiect la distanță Activ Nov 26, 2006

3 freelanceri plasează o ofertă medie de 62$ pentru proiect

dccherian

not ready to reduce the quality

$80 USD în 2 zile
(0 recenzii)
0.0