$catid=intval($_request['catid']);
$sql_store = 'select * from ecm_gcategory where cate_id=$catid order by cate_id';
$my_category= db::fetch_all($sql_store);
运行报如下错误:
select * from ecm_gcategory where cate_id=$catid order by cate_id
怎么解决哟?请高人指点!
回复讨论(解决方案) 报错如下:
1054) unknown column '$catid' in 'where clause'
select * from ecm_gcategory where cate_id=$catid order by cate_id
$sql_store = select * from ecm_gcategory where cate_id=$catid order by cate_id;
双引号!
单引号里面的变量不能被解析,需用双引号括起来。或者改成下面这样:
$sql_store = 'select * from ecm_gcategory where cate_id='.$catid.' order by cate_id';
