0 )){ mysql_select_db($database_BE2, $BE2); $delete_SQL = sprintf("delete from shop5 WHERE smid='%s'",$_GET['del_id']); mysql_query($delete_SQL, $BE2) or die(mysql_error()); mysql_select_db($database_BE2, $BE2); $delete_SQL = sprintf("delete from marketstreet WHERE mid='%s'",$_GET['del_id']); mysql_query($delete_SQL, $BE2) or die(mysql_error()); } $currentPage = $_SERVER["PHP_SELF"]; $maxRows_Rt2 = 12; $pageNum_Rt2 = 0; if (isset($_GET['pageNum_Rt2'])) { $pageNum_Rt2 = $_GET['pageNum_Rt2']; } $startRow_Rt2 = $pageNum_Rt2 * $maxRows_Rt2; $kid = '-1'; if (isset($_GET['selkid'])) { $kid = $_GET['selkid']; } mysql_select_db($database_BE2, $BE2); $query_Rt1 = "SELECT distinct(mname) FROM marketstreet where 1 " ; $Rt1 = mysql_query($query_Rt1, $BE2) or die(mysql_error()); $row_Rt1 = mysql_fetch_assoc($Rt1); if($kid == '-1'){ $kid=$row_Rt1['mname'] ;} mysql_select_db($database_BE2, $BE2); $query_Rt2 = sprintf("SELECT * FROM marketstreet where mname='%s' order by mcounty,mind",$kid); $query_limit_Rt2 = sprintf("%s LIMIT %d, %d", $query_Rt2, $startRow_Rt2, $maxRows_Rt2); $Rt2 = mysql_query($query_limit_Rt2, $BE2) or die(mysql_error()); $row_Rt2 = mysql_fetch_assoc($Rt2); $city=$row_Rt2['mcounty']; if (isset($_GET['totalRows_Rt2'])) { $totalRows_Rt2 = $_GET['totalRows_Rt2']; } else { $all_Rt2 = mysql_query($query_Rt2); $totalRows_Rt2 = mysql_num_rows($all_Rt2); } $totalPages_Rt2 = ceil($totalRows_Rt2/$maxRows_Rt2)-1; $queryString_Rt2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode("&", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_Rt2") == false && stristr($param, "totalRows_Rt2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_Rt2 = "&" . htmlentities(implode("&", $newParams)); } } $queryString_Rt2 = sprintf("&totalRows_Rt2=%d%s", $totalRows_Rt2, $queryString_Rt2); mysql_select_db($database_BE2, $BE2); $query_Rt3 = sprintf("SELECT * FROM marketmaster where msname='%s' ",$kid); $Rt3 = mysql_query($query_Rt3, $BE2) or die(mysql_error()); $row_Rt3 = mysql_fetch_assoc($Rt3); $totalRows_Rt3 = mysql_num_rows($Rt3); ?>
快速建立'; ?>

街道商圈管理

商圈選取
">

建立主圖
  主圖示 商圈名稱說明 連結
修改項目名稱 ''){?><?= $row_Rt3['msname'] ?>
0){ do { ?>
ID 城市 街道區域 商圈名稱說明 圖示 排序 啟用 刪除
修改項目名稱 ''){?> ">logo*/ ?> 刪除項目
總筆數：筆

0) { // Show if not first page ?> ">上一頁 第 頁 $totalPages_Rt2){ $start = $end-$totalPages_Rt2-5; $end=$totalPages_Rt2; } if ($end-$start>10){ $start = $end-10; } } for($i=$start;$i<=$end;$i++){ if($i==$pageNum_Rt2){ echo "[".($i+1)."]";} else {?> "> ">下一頁