Attached is a copy of the table structure for orders.
Each order has an Invoice_To and Ship_To.
The table also records a bunch of transport/brokerage charges - you can see them inside the red box.
I need someone to write a PHP script that will summarize the transport costs PER Selected Invoice_To OR Ship_To.
I will feed the Invoice_To OR Ship_To via URL and then I want the PHP script to do the math and show me which Transport_Company is charging me what on average for an order going to that customer.
I also need to know what the average % difference is between the Transport_Cost_Billed_To_Us and Transport_Cost_Quotation_Amount.
I need these statistics.
20 freelancers are bidding on average $147 for this job
Greetings! I am an expert at creating PHP scripts and writing queries to mysql and similar databases. Also, I work at reasonable rates. I have a vision in mind on how to achieve your task. please discuss