www.gusucode.com > citySHOP B2C商城系统 进销存 2.0.6码程序 > upload/crazybuylog.php

    <?php
include ('./include/common.inc.php');
$pagetitle = '最新评价';
$tpp = 30;
$page = max(1, intval($page));
$start_limit = ($page - 1) * $tpp;
$countnum = $db->result_first("SELECT COUNT(cid) FROM {$tablepre}crazybuylog");
$multipage = multi($countnum, $tpp, $page, "crazybuylog.php",100);
$query = $db->query("SELECT c.*,a.*,m.username,m.credits,ug.grouptitle,g.subject,ug.groupavatar FROM {$tablepre}crazybuylog c,{$tablepre}goods g,{$tablepre}members m LEFT JOIN {$tablepre}usergroups ug ON ug.groupid=m.groupid LEFT JOIN {$tablepre}address a ON a.uid=m.uid AND a.default=1 WHERE c.gid=g.gid AND m.uid=c.uid ORDER BY c.cid DESC LIMIT $start_limit,$tpp");
$replys = array();
$placeids = '0';
while($arr = $db->fetch_array($query)){
	$arr['gettime'] = strftime($timeformat,$arr['gettime']);
	$buylogs[] = $arr;
	$placeids .= $arr['area']?','.$arr['province'].','.$arr['city'].','.$arr['area']:'';
}
$query = $db->query("SELECT * FROM {$tablepre}places WHERE placeid IN ($placeids)");
$places = array();
while($arr = $db->fetch_array($query)){
	$places[$arr['placeid']] = $arr['name'];
}
include (template('crazybuylog'));
?>