#1 skyzong
一般的sql语句中in 用法是 id in(45,26,30)$id = $this->spArgs("id"); //输过来一个分类的id
如何查出 在表 的 classid 这个字段中符合的记录????
注 : classid 这个字段中的存储数据格式为
45,56,54
1,5,7
56,52
48,56
.......
findAll() 这里怎么写???
2013-06-08 16:51:18
2013-06-08 16:51:18
2013-06-09 11:43:12
function index(){ // 这里是首页SELECT COUNT(id) AS SP_COUNTER FROM agz_article WHERE find_in_set($bid,classid)
$post= spClass("lib_article");
$bid = $this->spArgs("bid");
if($bid){
$this->results = $post->spLinker()->spPager($this->spArgs('p', 1), 2)->findAll(' find_in_set($bid,classid)','intime DESC','id,title,concept,cityname,classname,classid,gznum,ytnum,logo');
}
$this->results = $post->spLinker()->spPager($this->spArgs('p', 1), 2)->findAll(null,'intime DESC','id,title,concept,cityname,classname,classid,gznum,ytnum,logo');
$this->pager = $post->spPager()->getPager();
}
2013-06-09 12:55:26
2013-06-09 17:22:50
zhgzzy 发表于 2013-6-9 12:55
SELECT COUNT(id) AS SP_COUNTER FROM agz_article WHERE find_in_set($bid,classid)
执行错误: Unknown co ...
2013-06-09 23:09:41
2013-07-01 05:26:31