MySelect("SELECT sb_files FROM signup_banner WHERE sb_enable = 1 ORDER BY sb_sort, sb_id"); $rs_banner = $sth_banner->fetchall(); // 取得縣市 $sth_city = $db->MySelect("SELECT city, city_code FROM city GROUP BY city, city_code ORDER BY city_code"); $rs_city = $sth_city->fetchall(); // 取得鄉鎮 $sth_dist = $db->MySelect("SELECT id, dist FROM city WHERE city_code = :city_code ORDER BY id", array("city_code"=>$rs_city[0]["city_code"])); $rs_dist = $sth_dist->fetchall(); // 取得活動說明 $sth_intro_1 = $db->MySelect("SELECT si_content FROM signup_intro WHERE si_id = 1"); $rs_intro_1 = $sth_intro_1->fetch(); // 取得活動詳情 $sth_intro_2 = $db->MySelect("SELECT si_content FROM signup_intro WHERE si_id = 2"); $rs_intro_2 = $sth_intro_2->fetch(); // 取得徐薇介紹 $sth_intro_3 = $db->MySelect("SELECT si_content FROM signup_intro WHERE si_id = 3"); $rs_intro_3 = $sth_intro_3->fetch(); // 取得連結按鈕/報名按鈕/徐薇照片 $sth_settings = $db->MySelect("SELECT ss_link_title1, ss_link1, ss_link_title2, ss_link2, ss_page_img, ss_finish_btn FROM signup_settings WHERE id = 1"); $rs_settings = $sth_settings->fetch(); ?>