实现本周文章点击排行

#1 zhgzzy

$getWeekDay=date("w");
$firstday=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-$getWeekDay+1,date("Y")));
$lastday=date("Y-m-d",mktime(0,0,0,date("m"),date("d")-$getWeekDay+7,date("Y")));

intime>$firstday and intime<$lastday 这一句如何写到下面:

$this->hots = $article->findAll(array('flag'=>1,'qid'=>$qid), 'hits DESC', 'id,title,hits',15);        //取最热文章15条

2010-11-12 15:17:26

#2 jake

find/findAll的第一个条件$condition可以用字符串的,代表SQL语句中WHERE后面条件。

$this->hots = $article->findAll("(intime>$firstday and intime<$lastday) AND 'flag' = 1 AND 'qid'=$qid", 'hits DESC', 'id,title,hits',15);        //取最热文章15条

2010-11-13 08:32:04