Find Jobs
Hire Freelancers

Combine rows with logic from MySQL table and output to JSON

$30-250 USD

Completed
Posted about 9 years ago

$30-250 USD

Paid on delivery
I have a MySQL table with multiple rows and on the JSON output I want to create a column tolerance and if the rows fit within that tolerance, combine the values and and average the tolerance column. See excel file for example of what I am trying to do. If the data on the left has a tolerance of 0.03 for the price column then the row is combined with the like rows. So the quantity is then added together and the price is then averaged. The rows that are body_row = 0 is a built in sum row for the symbol so that row is just ignored. My goal is that I can have a PHP file that does this on the fly and then uses json_encode to output the modified table data. Attached is the MySQL export of the data that I would like to use. In your proposal please tell me what color the highlighted rows are in the Excel spreadsheet so that I know that you opened the file. Thanks
Project ID: 7308308

About the project

7 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello again, Chad! I'm available for this project. Can begin right away. I look forward to your reply. Thanks. Kind Regards, Rajesh Soni
$157 USD in 1 day
5.0 (563 reviews)
7.7
7.7
7 freelancers are bidding on average $165 USD for this job
User Avatar
Hi, I have experience in PHP MySQL projects, if you check my reviews you will see that I have gotten excellent results from previous employers. If you have any questions or concerns please do not hesitate to contact me, thanks!
$200 USD in 3 days
4.9 (86 reviews)
7.1
7.1
User Avatar
A proposal has not yet been provided
$222 USD in 3 days
5.0 (1 review)
1.8
1.8
User Avatar
La propuesta todavía no ha sido proveída
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have checked your requirements.i have right skills to work on this assignment my award = superb result = happy client. In a good partnership, good results happen. Good cooking makes good eating!BWe consider our client as our partner. can u provide your email or sky-pe etc for further discussion about the project. I am ready to discuss with you with best Regards
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Rocklin, United States
5.0
12
Payment method verified
Member since Jul 27, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.