Как вывести количество новых новостей?

$sql_result = $db->query(«select ct.id,
(select count(*) from «. PREFIX .»_post ps where ps.category = ct.id AND (DATE_FORMAT(date, ‘%Y%m%d’)=CURDATE()) AND approve = ’1′) as new_,
(select count(*) from «. PREFIX .»_post ps where ps.category = ct.id AND approve = ’1′) as allnews_
from «. PREFIX .»_category ct»
);
while($row = $db->get_row($sql_result))
{
$tpl->set(‘{newcount_categ_’.$row['id'].’}', $row['new_']);
$tpl->set(‘{allcount_categ_’.$row['id'].’}', $row['allnews_']);
}