php資料庫連接錯誤

有代碼如下：

$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';

