$cateObj=db('cate');
$cateRes=$cateObj->order('sort ASC')->select();
$cates=$cateObj->find(input('id'));
----------------------------------------------
$cateObj=db('cate');
$cates=$cateObj->find(input('id'));
$cateRes=$cateObj->order('sort ASC')->select();
请问一下上面两种写法得出的sql为什么不样呢??
SELECT * FROM `fc_cate` WHERE `id` = 2 ORDER BY `sort` ASC
SELECT * FROM `fc_cate` WHERE `id` = 2 LIMIT 1
-----------------------------------------------------------------
SELECT * FROM `fc_cate` ORDER BY `sort` ASC
SELECT * FROM `fc_cate` WHERE `id` = 2 ORDER BY `sort` ASC LIMIT 1
$cates=db('cate')->find(input('id'));
直接这样写就没问题
最佳答案