tp中写原生sql语句,怎么实现分页和搜索功能?

浏览:2521 发布日期:2016/04/20 分类:求助交流 关键字: 分页,搜索。
$mode = M();
//$sql = "SELECT * FROM rt_work AS a WHERE a.id=(SELECT b.wid FROM `rt_pwwork` AS b WHERE a.`id` = b.`wid` )";
$id = $_SESSION['id'];
$sql = "SELECT * FROM rt_work WHERE id IN(SELECT wid FROM rt_pwwork WHERE pid=$id)";
$list = $mode->query($sql);
最佳答案
评论( 相关
后面还有条评论,点击查看>>