function getarea($areaid)
{
	global $dsql;
	if($areaid==0) return '';
	if(!is_object($dsql)) $dsql = new dedesql(false);
	$areaname = $dsql->GetOne("select name from #@__area where id=$areaid");
	return $areaname['name'];
}
示例#2
0
$starttime = mktime(0, 0, 0, $selectedmonth, $selectedday, $selectedyear);
$endtime = $starttime + 86400;
$where = '';
$tid = intval($tid);
if ($tid > 0) {
    $where = " and typeid={$tid}";
}
$pagesize = 30;
//默认一页30条数据
$maxpages = 9;
//
$pagepre = 4;
//分页用
$pageno = isset($_GET["pageno"]) ? intval($_GET["pageno"]) : 1;
$csql = "select count(*) as c from #@__archives,#@__arctype where pubdate>{$starttime} and pubdate <{$endtime} {$where} AND #@__archives.arcrank=0 AND #@__arctype.id = #@__archives.typeid";
$crow = $db->GetOne($csql);
$datacount = $crow['c'];
//总条数
$startrow = ($pageno - 1) * $pagesize;
//开始数
if ($datacount > 0) {
    $maxpage = $datacount % $pagesize;
    //
    if ($maxpage > 0) {
        $maxpage = ceil($datacount / $pagesize);
    } else {
        $maxpage = $datacount / $pagesize;
        //获取总页数
    }
} else {
    $maxpage = 0;