userinfo_dianp.php

城市分类信息,门户网站,我做为地方信息网

<?php



$page = intval($page);
$page = $page ? $page : 1;
$start = ($page==1)? 0 : ($page-1) * $webcommentlist;

$query = $DB->query("SELECT cmtid FROM {$tablepre}comment WHERE uid='$uid'");
$num = $DB->num_rows($query);
$page = commonPage($page, $num, '../user/userinfo.php?action=dianp&uid='.$uid, $webcommentlist);

$query = $DB->query("SELECT c.*, t.*, b.biz_name FROM {$tablepre}comment as c LEFT JOIN {$tablepre}bizpoint as t ON t.uid=c.uid AND t.bizid=c.bizid LEFT JOIN {$tablepre}bizinfo as b ON b.bizid=c.bizid WHERE c.uid='$uid' ORDER BY cmtid DESC LIMIT $start, $webcommentlist");

while($rs = $DB->fetch_array($query)) {
	$rs['dateline'] = date('Y-m-d H:i:s', $rs['dateline']);
	$rs['point'] = round(($rs['a']+$rs['b']+$rs['c']) / 30 * 5);
	$rs['a'] = $rs['a'] / 2;
	$rs['b'] = $rs['b'] / 2;
	$rs['c'] = $rs['c'] / 2;
	$rs['content'] = nl2br($rs['content']);
	$cmt_list[] = $rs;	
}
include showPage('userinfo_dianp');
?>