Combine rows with logic from MySQL table and output to JSON
$30-250 USD
Terminado
Publicado hace alrededor de 9 años
$30-250 USD
Pagado a la entrega
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
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!
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