In Progress

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:[url removed, login to view]: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:[url removed, login to view]: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

5 freelancers are bidding on average $49 for this job

ivan381eu

Please check private message I sent you.

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

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

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

Dear Respected Client, Good Day I’m interested in the position of -hp expert for fixing an import to mysql error- you recently [url removed, login to view] check pm.

$90 USD in 2 days
(23 Reviews)
5.0
a4ren

i can do this very [url removed, login to view] check your PM.

$30 USD in 1 day
(0 Reviews)
0.0