﻿ <?php require_once('../Connections/BE2.php'); ?>
<?php 
$citylink=array("台北市","新北市","基隆市","桃園市","新竹市","新竹縣","宜蘭縣","臺中市","苗栗縣","彰化縣","南投縣","雲林縣",
             "高雄市","臺南市","嘉義市","嘉義縣","屏東縣","花蓮縣","臺東縣","澎湖縣","金門縣","連江縣");
$cityname=array("台北市","新北市","基隆市","桃園市","新竹市","新竹縣","宜蘭縣","臺中市","苗栗縣","彰化縣","南投縣","雲林縣",
          "高雄市","臺南市","嘉義市","嘉義縣","屏東縣","花蓮縣","臺東縣","澎湖縣","金門縣","連江縣" );
$cityimg=array("taipei","newtaipei","keelung","taoyuan","hsinchucity","hsinchu","yilan","taichuan","miaoli","changhua","nantou","yunlin",
   "kaohsiung","tainan","chiayicity","chiayi","pingtung","hualien","taitung","penghu","kinmen","lienchiang");
 
/*   
for($i=0;$i<count($citylink);$i++){
  $insertSQL = sprintf("INSERT INTO city_img (ctname,ctlink,ctimg,ctindex) VALUES ('%s', '%s','%s','%s')",
  $cityname[$i],$cityname[$i],$cityimg[$i],$i*100  );
  mysql_select_db($database_BE2, $BE2);
  mysql_query($insertSQL, $BE2) or die(mysql_error());
  
}
 
 */  
?>
