Guest Posted October 7, 2008 Share Posted October 7, 2008 how can i get all the shippingcost from all orders out and then sum them together. i need this to calculate the shippingcost i add to my orders is somewhere around what i actualy pay for the shipping. hope you understand what i mean.. do i find this in the sql. and how can such code look like Link to comment Share on other sites More sharing options...
L!mit Posted October 7, 2008 Share Posted October 7, 2008 Check out the tax report contributions some of them have shipping cost break downs. Link to comment Share on other sites More sharing options...
Guest Posted October 8, 2008 Share Posted October 8, 2008 i dont want a contribution. just a smal code to get shiping out of my sql and calculate the total of it. i got the code figured out. /*totalshiping*/ $shiping_query="SELECT SUM(value) FROM orders_total WHERE class LIKE 'ot_shipping'"; $shiping_result = mysql_query($shiping_query); $shiping_price = mysql_fetch_row($shiping_result); <td class="pageHeading">Total shipingfrom my orders: <? echo floatval($shiping_price[0]); ?> Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.