SQL statement
View Answers
May 24, 2008 at 7:16 PM
Hi
"SELECT od_shipping_cost CASE WHEN SUM(pd_price * od_qty) < 300 THEN od_shipping_cost = 0 ELSE
od_shipping_cost = 10 END FROM tbl_order, tbl_order_item oi, tbl_product p
WHERE oi.pd_id = p.id_id and oi.pd_id = $orderId";
"SELECT od_shipping_cost CASE WHEN SUM(pd_price * od_qty) < 300 THEN od_shipping_cost = 0 ELSE
od_shipping_cost = 10 END FROM tbl_order, tbl_order_item oi, tbl_product p
WHERE oi.pd_id = p.id_id and oi.pd_id = $orderId";
May 27, 2008 at 9:51 PM
It seems like u gave me the exact same code had witten
Related Tutorials/Questions & Answers:
Ads
