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')); ?>