Find Jobs
Hire Freelancers

database table listing

$20-100 USD

Closed
Posted almost 20 years ago

$20-100 USD

Paid on delivery
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
Project ID: 2992

About the project

3 proposals
Remote project
Active 17 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
3 freelancers are bidding on average $62 USD for this job
User Avatar
not ready to reduce the quality
$80 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
0.0
1
Member since Jul 6, 2004

Client Verification

Other jobs from this client

oscommerce partner
$20-100 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.