//----一个字段 列如status 值 是1或者2、3、4、5、6
要通过5、3、2进行排序
排序方法:public function zy_list($openid){
$sql ="SELECT c. * , z. * FROM `ldx_consultants` AS z JOIN ldx_customer AS c ON z.cid = c.cid WHERE c.`bstate` IN ( 5, 1, 7, 6) and z.`openid`='$openid' ORDER BY FIELD( c.`bstate` , 5, 1, 7, 6)";
$arr =$this->query($sql);
return $arr;
}
主要是 where 后要有in 还有排序方式 order by field