需要的拿去哦。很好一条语句搞定,

$sql="select DISTINCT(typeid) from dede_archives Where DATE_FORMAT(FROM_UNIXTIME(pubdate),'%Y-%m-%d') = DATE_FORMAT(NOW(),'%Y-%m-%d') order by id desc";