Ditutup

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

Kemahiran: PHP

Lihat lebih lanjut: 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

Tentang Majikan:
( 1 ulasan ) London, United Kingdom

ID Projek: #2992

3 freelancers are bidding on average $62 for this job

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 Lagi

$55 USD dalam 2 hari
(0 Ulasan)
0.0
webmaster1212

hello friend,i am interested to wok with [url removed, login to view] i have four years experience in web [url removed, login to view]'s very easy,i can complete it in one [url removed, login to view] can check my recently developed sites like [url removed, login to view],sendowr Lagi

$50 USD dalam sehari
(0 Ulasan)
0.0
dccherian

not ready to reduce the quality

$80 USD dalam 2 hari
(0 Ulasan)
0.0