query($sql) as $row){ array_push($genre, $row); } //大阪版VIPバナー数取得 $stmt = $dbh->prepare("SELECT COUNT(*) FROM `banner` WHERE (`flg` = 0) AND (`classification` = 0) AND (`col` = 0)"); $stmt -> execute(); $vipbanner_osaka_count = (int)$stmt->fetchColumn(); $stmt -> closeCursor(); //京都版VIPバナー数取得 $stmt = $dbh->prepare("SELECT COUNT(*) FROM `banner` WHERE (`flg` = 0) AND (`classification` = 0) AND (`col` = 1)"); $stmt -> execute(); $vipbanner_kyoto_count = (int)$stmt->fetchColumn(); $stmt -> closeCursor(); //エリア（大阪版） $area_array01 = array(); $sql = "SELECT * FROM `area` WHERE (`flg` = 0) AND (`col` = 0)"; foreach($dbh -> query($sql) as $row){ array_push($area_array01, $row); } //エリア（京都版） $area_array02 = array(); $sql = "SELECT * FROM `area` WHERE (`flg` = 0) AND (`col` = 1)"; foreach($dbh -> query($sql) as $row){ array_push($area_array02, $row); } ?> 求人掲載のご案内 ｜ 【京阪ガール】 ナイトワーク専門！高時給バイト情報

求人掲載のご案内