Cancelled

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

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

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

line4->player2/time:22:10:06/backodds:1.4/layodds:[url removed, login to view]

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

should have been

time:22:10:07/backodds_player1:3/backodds_player2:[url removed, login to view]:3.1/layodds_player2:1.5

Skills: MySQL, PHP

See more: update mysql, php expert, php error fixing, one line php, mysql error, import mysql, error fixing, mysql database import, time today php, update database mysql, mysql update database, mysql data import, php update file, php player match, error time, php mysql database expert, expert entry, php data database update, time need php expert, database update data entry, database odds, update data mysql, php file match, need php expert , expert import

About the Employer:
( 41 reviews ) Skanderborg, Denmark

Project ID: #1298075