SQL 怎样判断订单列表是否已发货

2016-07-07 15:03 来源:www.chinab4c.com 作者:ecshop专家

我想判断订单列表是否已发货

  1. $sql="select o.order_sn,o.consignee,o.address,o.tel,o.add_time,o.shipping_name,o.pay_name,g.goods_name,g.goods_attr,g.goods_number,u.user_name from". $GLOBALS['ecs']->table('order_info').
  2. " as o left join " . $GLOBALS['ecs']->table('users')." as u on o.user_id=u.user_id "."left join". $GLOBALS['ecs']->table('order_goods')." as g on o.order_id=g.order_id ";
  3. $res=$db->getAll($sql);
复制代码


上面代码应该怎么改呀,小白菜的我不会呀,各位老大帮帮看!!