6688

1.    $sql = "SELECT order_id,order_sn,invoice_no,shipping_name,sign_building FROM " .$ecs->table('order_info').
   
2. 
   
3.             " WHERE user_id = '$user_id' AND shipping_status = '0' ";

复制代码

想加个条件，sign_building（默认为空）这个字段只要内容才可以查询。

小闲云野鹤

1. $sql = "SELECT order_id,order_sn,invoice_no,shipping_name,sign_building FROM " .$ecs->table('order_info'). " WHERE sign_building <> '' and user_id = '$user_id' AND shipping_status = '0' ";

复制代码

yufan163

where sign_building is not null