Closed

MySQL table/custom query setup

Currently looking for quotes on setting up an _additional_ MySQL table in my existing database that would relate to current/existing tables. Need help with the field formatting.

Would then need development of a query to pull information from this table as well as existing tables for custom .php data report page. This will probably require specific functions, etc. to be programmed into the .php page.

---PURPOSE---

I currently run a website for a circuit that organizes competitions between high school groups. Currently the scheduling is done through excel, exported to HTML, cleaned up and uploaded. Everytime there is a change to the list of groups competing at any given competition, it's a multi-step process to update, because the scheduling is set up by 'competing class' for a specific date. Each 'competing class' has a different time interval in which they are allowed to compete (class1=5 minutes, class2=6 minutes, etc.). Excel is smart enough to use formulas, but I do not know how to do calculations of TIME in MySQL. All existing data (group name, class, etc.) can and will be setup prior to any development of this new table. Theoretically, the new table would be relatively simple. The query & PHP page is where I get in over my head. This would set a schedule of all groups at CONTEST_A sorted by CLASS, working either **_backwards or forwards_** from ENDTIME (10pm for example) or STARTTIME (3pm example).

examples of current schedules & table setup:

existing schedule - working backwards from END TIME: [url removed, login to view]

existing EXCEL schedule - working forwards from START TIME: [url removed, login to view]

existing tables & new table setup: see Excel download above...

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP or Mac OSX

Skills: Engineering, MySQL, PHP, Software Architecture, Software Testing, User Interface / IA, Web Hosting, Website Management, Website Testing

See more: sorted data set, smart coder, pull data from website into excel, new hire quotes, mysql software download, mysql database download for windows, how to compete, high end engineering, download mysql database for windows, custom php coder, custom list in excel, custom formulas in excel, custom database development, custom coder hire, compete software, compete data, central seller, download mysql, time table, smart xls, simple query, query table, net custom software, mysql report, db query

About the Employer:
( 2 reviews ) United States

Project ID: #3111742

18 freelancers are bidding on average $52 for this job

AndrwProjects

See private message.

$63.75 USD in 14 days
(177 Reviews)
6.3
vevssl

See private message.

$59.5 USD in 14 days
(82 Reviews)
6.3
harisraheem

See private message.

$42.5 USD in 14 days
(24 Reviews)
6.1
makavelivw

See private message.

$21.25 USD in 14 days
(181 Reviews)
6.0
cinterosystems

See private message.

$51 USD in 14 days
(141 Reviews)
5.6
alancaster

See private message.

$63.75 USD in 14 days
(24 Reviews)
5.2
cdmanvw

See private message.

$34 USD in 14 days
(44 Reviews)
5.0
mstrocan

See private message.

$34 USD in 14 days
(65 Reviews)
4.7
samuraisystemsvw

See private message.

$85 USD in 14 days
(34 Reviews)
4.4
jlampa

See private message.

$68 USD in 14 days
(19 Reviews)
4.3
parasoftvw

See private message.

$42.5 USD in 14 days
(10 Reviews)
3.4
topinfosysvw

See private message.

$85 USD in 14 days
(3 Reviews)
2.8
jeremy648

See private message.

$76.5 USD in 14 days
(3 Reviews)
1.7
robcompware

See private message.

$34 USD in 14 days
(3 Reviews)
1.4
florinbotavw

See private message.

$42.5 USD in 14 days
(0 Reviews)
0.0
strimen

See private message.

$21.25 USD in 14 days
(0 Reviews)
0.0
vladker

See private message.

$42.5 USD in 14 days
(0 Reviews)
0.0
meenalvw

See private message.

$68 USD in 14 days
(0 Reviews)
0.0