Design MySQL Database Structure + php test page

In Progress

Dear Coders,

I'm looking to develop a website and I need help getting started. The website lists golf course prices according to the date and time range the user selects. Golf course prices are quite complicated as they have different rates for different times and days.

See examples here [url removed, login to view]

For this project, I'm looking for an expert in MySQL databases and php, that will design an efficient MySQL database structure to store price data like these. Please keep in mind that the final database may be over 20,000 golf courses.

The next part of this project is to create a php test page. The user will select a date and inputs a time range (start and end), the output should be the prices within the time range for all of the 3 example courses.

Example:

User inputs Oct 20, 2010 (Wednesday) and 11:20am to 3:20pm

PHP Script outputs (according to example above)...

Course #1

11:20am to 1:26pm = $39

1:27pm to 3:14pm = $29

3:15pm to 3:20pm = $19

Course #2

11:20am to 1:30pm = $33

1:31pm to 2:30pm = $28

2:31pm to 3:20pm = $23

Course #3

11:20am to 3:20pm = $40

I'm looking to select a coder for this project within the first 4 hours, so please be ready to start working right away as the deadline for the completion of this project is 48 hours.

Thanks for your interest,

-E

Skills: PHP

See more: no structure, lists data structure, examples of data structure, design a data structure, data structure examples in c, data structure examples, data structure example, data structure design, database design prices, php courses, design rates, Structure, php test, mysql database , mysql database design, golf courses, design develop database, structure php, php test page, database project php, php install page, mysql completion, mysql date within days, will design

Project ID: #3794983

Awarded to:

vw7488728vw

See private message.

$34 USD in 3 days
(19 Reviews)
3.2

19 freelancers are bidding on average $96 for this job

mushrraf

See private message.

$29.75 USD in 3 days
(94 Reviews)
6.5
umnuscom

See private message.

$76.5 USD in 3 days
(115 Reviews)
5.8
Alioth

See private message.

$68 USD in 3 days
(49 Reviews)
5.8
Thutat

See private message.

$255 USD in 3 days
(37 Reviews)
5.3
toinnisfreesl

See private message.

$170 USD in 3 days
(38 Reviews)
5.3
inadilemma

See private message.

$42.5 USD in 3 days
(41 Reviews)
5.1
mdimranurrahman

See private message.

$68 USD in 3 days
(19 Reviews)
4.9
bdlancer09

See private message.

$68 USD in 3 days
(49 Reviews)
4.6
ThinkDone1

See private message.

$255 USD in 3 days
(7 Reviews)
4.3
usmanehsan

See private message.

$170 USD in 3 days
(27 Reviews)
3.9
pharaox

See private message.

$51 USD in 3 days
(22 Reviews)
3.3
niko1

See private message.

$42.5 USD in 3 days
(14 Reviews)
3.2
sabasoftisb

See private message.

$42.5 USD in 3 days
(10 Reviews)
2.4
hopervw

See private message.

$55.25 USD in 3 days
(8 Reviews)
2.3
saadmohamedvw

See private message.

$42.5 USD in 3 days
(5 Reviews)
2.0
russelarnld

See private message.

$225.25 USD in 3 days
(1 Review)
0.0
aftabafzaal

See private message.

$85 USD in 3 days
(0 Reviews)
0.0
ambilysaju

See private message.

$42.5 USD in 3 days
(0 Reviews)
0.0