";
$wh = ''; if( !empty($nid) )
{
$nids = explode('`',$nid); foreach($nids as $n)
{ if($wh=='') $wh = " WHERe o.oid='$n' "; else $wh .= " OR o.oid='$n' ";
}
}
$sql = "SELECT o.*,p.title,p.price as uprice,d.dname,u.* FROM xjq_shops_orders as o left join xjq_shops_products as p on o.oid=p.oid left join xjq_shops_delivery as d on d.pid=o.pid LEFT JOIN xjq_shops_userinfo AS u ON o.oid=u.oid $wh";
$dsql->SetQuery($sql);
$dsql->Execute('t'); while($arr = $dsql->GetArray('t'))
{ echo "
评论列表(0条)