Seiji Sogabe
s.sog****@gmail*****
2007年 2月 8日 (木) 23:31:22 JST
曽我部です。 Kobayashi wrote: > ot.class = 'ot_shipping' の追加方法 > ot.text as order_total と ot.title as shipping_method の処理方法が解らず、 > 表示できないでいます。 $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total, ot1.title as shipping_method from ( " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id)) left join " . TABLE_ORDERS_TOTAL . " ot1 on (o.orders_id = ot1.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . tep_db_input($cID) . "' and o.orders_status = s.orders_status_id and s.language_id = '" . $languages_id . "' and ot.class = 'ot_total' and ot1.class = 'ot_shipping' order by orders_id DESC"; でどうですか。 -- sogab****@alles*****
