MySql & Php two small sripts
€8-30 EUR
Paid on delivery
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.
Project ID: #18743666
About the project
6 freelancers are bidding on average €29 for this job
hi i am magento developer with having more than seven year of experience. please visit my profile so you will see i have done lot of projects here. i see your requirements and i will do this job.
Hi, I could do these scripts. I developed many MySQL databases. Looking forward to work with you. Regards.
Hi I am very much interested in your project I have 5 years of experience in mysql First i will provide you the solution and you will check by your self No payment and charges until you are satisfied kindly contact More
Hello, I have read your descriptions carefully. MySQL and script are my major skills. So I can meet all of your requirements enough. If the above offer sounds like something you would be interested in, I'd love to hear More