如何显示数据从mysql在PHP中垃圾桶!= 1(列值)

Question

我只想显示垃圾桶= 1 from PHP mysql in PHP垃圾变量是PHP mysql的列字段，我存储的值为1。因此，我只检索垃圾桶的行= null

//Below mentioned code for check order status
$o_status = @$_GET['o_status'];
if(isset($o_status) and !empty($o_status)){
$o_where = array('order_s'=>$o_status);
}else if(isset($type) and !empty($type)){
//$o_where = array('status'=>1,'order_show_off'=>"No",'status'=>1);
}else{
//$o_where = array('status'=>1, 'status'=>1);
}
//And in last line of code for searching for all data
$cou_list = $con->all_fetch("orders",$o_where," group by order_id, vendor_id order by id desc");

提前谢谢你

我期待一个解决方案，我的问题在代码术语或可能一些指导

Answer 1

您应该使用where子句进行查询，例如

Select * From tables Where (Trash = Null)