database table listing

Closed

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

Skills: PHP

See more: primary job, php create table, php code to 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, database classes

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

Project ID: #2992

3 freelancers are bidding on average $62 for this job

dccherian

not ready to reduce the quality

$80 USD in 2 days
(0 Reviews)
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 More

$50 USD in 1 day
(0 Reviews)
0.0
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 More

$55 USD in 2 days
(0 Reviews)
0.0