我在php的拼写的sql语句,输入后是这样的select * from `zx_solutions` where s_id = 6把这条语句放在数据库中执行,报以下错误:
[SQL]
select * from `zx_solutions` where s_id = 6[Err] 1054 - Unknown column '6' in 'where clause'请高手指点:
[SQL]
select * from `zx_solutions` where s_id = 6[Err] 1054 - Unknown column '6' in 'where clause'请高手指点:
这样
$sql = "select * from zx_solutions where s_id = $sid";
echo $sql;
$rs = $this->db->query($sql);
return $rs;
}
你用的什么数据库,zx_solutions 表结构是怎样的。最好全部列出来。
select * from '表名' where 字段名 = '6'有可能是符号打错了
$sql = "select * from zx_solutions where s_id =".intval($sid);
echo $sql;
$rs = $this->db->query($sql);
return $rs;
}