userinfo_bnbiz.php

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

<?php



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

$query = $DB->query("SELECT buid FROM {$tablepre}bizuser WHERE uid='$uid' AND been='1'");
$num = $DB->num_rows($query);
$page = commonPage($page, $num, '../user/userinfo.php?action=bnbiz&uid='.$uid, $webbizlist);

$query = $DB->query("SELECT bu.*, bf.biz_name, bf.biz_photo FROM {$tablepre}bizuser as bu LEFT JOIN {$tablepre}bizinfo as bf USING(bizid) WHERE uid='$uid' AND been='1' LIMIT $start, $webbizlist");
while($rs = $DB->fetch_array($query)) {
	$rs['biz_photo'] = empty($rs['biz_photo']) ? WEB_URL . 'images/common/noimg.jpg' : WEB_URL . 'webdata/biz_images/'.$rs['biz_photo'];
	$bizlist[] = $rs;	
}
include showPage('userinfo_bnbiz');
?>