public function search(){
if(IS_POST){
$keyword=I('post.keyword');
$lastnews=sp_sql_posts("field:post_title,object_id,term_id,post_date,smeta;order:listorder asc,post_date desc;limit:5;where:post_level=0 and post_title like '%$keyword%'");
$this->assign('keyword', $keyword);
$this->assign('lastnews', $lastnews);
$this->display(":search");
}
}
public function moresearch() {
if(IS_AJAX){
$limit = I('post.limit');
$keyword = I('post.keyword');
//$model=M('posts');
//$rs=$model->join('table_term_relationships ON table_term_relationships.object_id = table_posts.id')->field('post_title,object_id,term_id,post_date,smeta')->where('table_posts.post_level=0 and table_posts.post_title like '%$keyword%'')->limit($limit)->order('listorder asc,post_date desc')->select();
$rs=sp_sql_posts("field:post_title,object_id,term_id,post_date,smeta;order:listorder asc,post_date desc;limit:$limit;where:post_level=0 and post_title like '%$keyword%'");
$this->ajaxReturn(array("msg"=>"ok","rs"=>$rs));
}
}注释掉那个部分，用join写的，是可以读出数据来的，但是where失效……search里面的数据可以获取到，但是moresearch里面用sp_sql_posts("field:post_ti
请高手帮忙！！
最佳答案
