Question

PHP数据库语法，下面的$sql = "select * from $table where $where order by id desc "; 有错吗？

function get_zj_str($customerid,$admin_id,$table,$title_field,$divdesc) {
if($customerid){

$where .= " customerid='$customerid'";
}

if($admin_id){

$where .= " admin_id='$admin_id'";
}

if($divdesc=="dati") {
$where .= " and type=0";

}
$sql = "select * from $table where $where order by id desc ";

Answer 1

单从php语法上似乎没有错
只是你检测下，sql语句和数据库结构是否对应
主要是引号的问题！
如：字段属性和sql中字段对应的值，加不加引号是有区别的！
并不是任何类型的字段，在对应值的时候加不加引号都一样！
加与不加，区别大了去了！

Answer 2

$where .= " customerid='$customerid'";

把里面的单引号去掉、

Answer 3

$where 为空时会出错，最好在前面加个判断 $where = $where ? $where : '1=1';

Answer 4

双引号｛$变量｝ 要这样写吧