下面的sql即可实现：

查看源码打印代码帮助01 $dsql->SetQuery("SELECT arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,

02tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp

03 on arc.typeid=tp.id WHERE

04 FROM_UNIXTIME(arc.senddate,'%Y-%m-%d') = "."'".date('Y-m-d')."'");

05 $dsql->Execute();

06 while ($rows = $dsql->GetArray()) {

07 $rows['url'] = GetFileUrl($rows['id'],$rows['typeid'],$rows['senddate'],$rows['title'],$rows['ismake'],

08$rows['arcrank'],$rows['namerule'],$rows['typedir'],$rows['money'],$rows['filename'],$rows['moresite'],$rows['siteurl'],

09$rows['sitepath']);

10 $arcArray[] = $rows;

11 }