MySql & Php two small sripts

Need two small scripts to rearrange existing MySQL database.

Example of existing database entry:

"id","game","score","1","X","2","date"

"AUTO INCREMENT","Arsenal - Fulham","Final result 4:0 (3:0, 1:0)","1.21 ","6.99 ","18.30 ","Sunday, 09 May 2010"

1st script

Organize entries from existing database into new database using following format.

"id","game","total score","1HT","2HT","1","X","2","date"

"AUTO INCREMENT","Arsenal - Fulham","4:0","3:0","1:0","1.21 ","6.99 ","18.30 ","Sunday, 09 May 2010"

There is large amount of entries so script should pause few seconds after processing 100 entries at the time.

2nd script.

Organize entries from existing database into new database using following format.

"id","1X2","rating","date"

"AUTO INCREMENT","1","1","Sunday, 09 May 2010"

Where 1x2 field -

if "Final result" first team win (1:0, 2:0 etc) = 1

if "Final result" second team win (0:1,0:2 etc) = 2

if "Final result" draw (0:0, 1:1 etc) = 3

Where "rating" field using data from existing mysql fields "1","X","2",

As follow: if "1x2 field" if first team win we use field "1" for rating, if second team win we use "2" , if draw we use "X" field

The figure in 1, X, 2 fields should be rounded in following format:

If figure 1.2 we round to 1, if 1.3 we round to 1.5 , if 1.6 we round to 1.5, if 1.7 round to 2.

If figure > 8 we round to 8.

There is large amount of entries so script should pause few seconds after processing 100 entries at the time.

Programmazione Database MySQL PHP Architettura Software SQL

Rif. progetto: #18743666

Info sul progetto