bizcate_count.php

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

<?php



if(!defined('IN_FLY')) {
	exit('Access Denied');
}

cpheader();

$query = $DB->query("SELECT bizid, biz_cid, biz_sort FROM {$tablepre}bizinfo");

$tmp = '';
while($rs = $DB->fetch_array($query)) {
	$cate[$rs[biz_cid]]++;
	
	$tmp =explode(",", $rs['biz_sort']);
	
	foreach($tmp as $var) {
		$sort[$var]++;
	}
}

$DB->query("UPDATE {$tablepre}bizcate SET bizs='0'");

foreach($cate as $key => $var) {
	$DB->query("UPDATE {$tablepre}bizcate SET bizs='$var' WHERE cid='$key'");
}

foreach($sort as $key => $var) {
	$DB->query("UPDATE {$tablepre}bizcate SET bizs='$var' WHERE cid='$key'");
}

cpmsg('缁熻