Suljettu

database table listing

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

Taidot: PHP

Näytä lisää: primary job, php create table, php code create report, int i, create table php, 13524, table, sponsor, smith, primary, null, mech, listing of, int, data listing, aid, php data table, php miss, create report database php, can database, report table, table php, datetime, thank, php create report database

About the Employer:
( 1 review ) London, United Kingdom

Projektin tunnus: #2992

3 freelanceria on tarjonnut keskimäärin 62 $ tähän työhön

maulik4u

Dear Sir, Why Choose US ? We are India based company working in IT field with experience of more than 7 years. We have done so many projects related to - ASP, .NET,VB,PHP, c, C++ etc., - WEBSITE DEVELOPMEN Lisää

55 $ USD 2 päivässä
(0 arvostelua)
0.0
webmaster1212

hello friend,i am interested to wok with you.well i have four years experience in web development.it's very easy,i can complete it in one day.you can check my recently developed sites like topsalespositions.com,sendowr Lisää

50 $ USD 1 päivässä
(0 arvostelua)
0.0
dccherian

not ready to reduce the quality

80 $ USD 2 päivässä
(0 arvostelua)
0.0