bizlmlist.php

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

<?php



require_once '../include/common.php';

$cidinfo = '';
$cid = intval($cid);

$pagelink = "../mall/bizlmlist.php";

if($cid) {
	$tmp = $DB->get_one("SELECT cid FROM {$tablepre}bizcate WHERE cid='$cid' AND fup='0'");	
	if ($tmp) {
		$cidinfo = "AND b.biz_cid='$cid'";
		$pagelink = "../mall/bizlmlist.php?cid=" . $cid;
	}
}

$query = $DB->query("SELECT * FROM {$tablepre}bizcate WHERE fup='0' ORDER BY cid ASC");
while($rs = $DB->fetch_array($query)) {
	$bizsort_list[] = $rs;
}


$page = intval($page);
$page = $page ? $page : 1;
$start = ($page==1)? 0 : ($page-1) * $webbizlist;
	
$query = $DB->query("SELECT b.bizid FROM {$tablepre}bizinfo as b WHERE b.cardtxt<>'' $cidinfo");
$num = $DB->num_rows($query);

$page = commonpage($page, $num, $pagelink, $webbizlist);

$query = $DB->query("SELECT * FROM {$tablepre}bizinfo as  b LEFT JOIN {$tablepre}bizinfomore as m ON m.bmid=b.bizid WHERE b.cardtxt<>'' $cidinfo");
while($rs = $DB->fetch_array($query)) {
	$rs['biz_phone'] = empty($rs['biz_phone']) ? '鏆傛棤' : $rs['biz_phone'];
	$rs['biz_address'] = empty($rs['biz_address']) ? '鏆傛棤' : $rs['biz_address'];
	$rs['biz_fax'] = empty($rs['biz_fax']) ? '鏆傛棤' : $rs['biz_fax'];
	
	$rs['biz_photo'] = empty($rs['biz_photo']) ? "../images/common/noimg.jpg" : "../webdata/biz_images/" . $rs['biz_photo'];
	$rs['biz_link']  = '../main/bizinfo.php?bizid='.$rs['bizid'];
	
	$rs['biz_intro'] = cutstr($rs['biz_intro'], 180);
	
	if($rs['tuijian']) {
		$bizinfo_tj_list[] = $rs;
	}
	$bizinfo_list[] = $rs;
}


include showpage('bizlmlist');
?>