"; else $newpic =""; echo ""; $index++; } ?>
".$row['pubname']." ".$row['address']." ".$newpic."
"; $sql = "select * from hzpub_areainfo where description <> '其它'"; $rs = mysql_query($sql); $options=$options.""; while($row = mysql_fetch_array($rs)) { if($areakey == $row['description']) $options= $options.""; else $options= $options.""; } if($areakey == "其它") $options=$options.""; else $options=$options.""; echo ""; ?>
输入相关的酒吧关键字进行搜索
"; } else { $sql = "select * from hzpub_areainfo where description ='".$areakey."'"; $rs = mysql_query($sql); $row = mysql_fetch_array($rs); if(!empty($row)) $areasearch = "and areaid=".$row['areaid']; $sql = "select count(pubid) as pubcount from hzpub_pubinfo where (pubname like '%".$pubkey."%' or description like '%".$pubkey."%') ". $areasearch; $rs = mysql_query($sql); $row = mysql_fetch_array($rs); $pubcount = $row['pubcount']; $sql = "select pubid, pubname, address from hzpub_pubinfo where (pubname like '%".$pubkey."%' or description like '%".$pubkey."%') ". $areasearch." limit ".$offset.",".$countperpage; $rs = mysql_query($sql); $pages = (int)($pubcount / $countperpage) + (int)((int)($pubcount % $countperpage) > 0?1:0); echo "
共搜索到 ".$pubcount." 个相关酒吧
"; while($row = mysql_fetch_array($rs)) { echo "
".$row['pubname']." ".$row['address']."
"; } $pageoffset = (int)$offset; if($pageoffset == 0 && $pages > 1) { echo "
"; } else if($pageoffset/$countperpage >= $pages - 1&& $pages > 1) echo "
"; else if($pages > 1) echo "
"; } ?>

 

  网站地图 | 公司介绍 | 合作洽谈 | 广告刊登 | 联系我们