Completed

hp expert for fixing an import to mysql error

Today a odds file is being imported into mysql database.

It contains odds change information for each second of the match (and before)

To lines with data (one for each player) is imported as one entry

Doing import with an option that do not update an entry if it is same odds as previous one, i found an error.

example:

line1->player1/time:22:10:05/backodds:3/layodds:3.1

line2->player2/time:22:10:05/backodds:1.4/layodds:1.39

---->this line is updated correctly into database in one entry for:

time:22:10:05/backodds_player1:3/backodds_player2:1.4/layodds_player1:3.1/layodds_player2:1.39

line3->player1/time:22:10:06/backodds:3/layodds:3.1

line4->player2/time:22:10:06/backodds:1.4/layodds:1.39

---->this line is not updated because odds is same

line5->player1/time:22:10:07/backodds:3/layodds:3.1

line6->player2/time:22:10:07/backodds:1.49/layodds:1.5

---->this line is wrong updated (player2 data is updated from line4, not line6)

time:22:10:07/backodds_player1:3/backodds_player2:1.4/layodds_player1:3.1/layodds_player2:1.39

should have been

time:22:10:07/backodds_player1:3/backodds_player2:1.49/layodds_player1:3.1/layodds_player2:1.5

Skills: PHP

See more: update mysql, php error fixing, mysql error, import mysql, import database, hp, error fixing, mysql database import, update database mysql, mysql update database, mysql data import, php player match, error time, import import, php mysql database expert, expert entry, database update data entry, database odds, update data mysql, expert import, player found, php mysql entry, import lines, match odds database, php data entry mysql

About the Employer:
( 41 reviews ) Skanderborg, Denmark

Project ID: #1298076

Awarded to:

bdlancer09

Can do right now.

$40 USD in 1 day
(45 Reviews)
4.5

4 freelancers are bidding on average $39 for this job

ivan381eu

Please check private message I sent you.

$50 USD in 0 days
(28 Reviews)
6.5
sscreations

Hi Sir, I am ready to start, lets discuss on PMB

$35 USD in 1 day
(37 Reviews)
6.0
a4ren

i can do this very [login to view URL] check your PM.

$30 USD in 1 day
(1 Review)
3.7