">
北海道地方"); while($res01 = mysql_fetch_array($result01,MYSQL_ASSOC)){ if($res01['open_name'] != ""&& $res01['area'] == "北海道"){ print("【".$res01['area']."】".$res01['open_name']." "); } } print(" | ");
//////////////////////////////
$result01 = mysql_query("select * FROM member WHERE state = '1' && display ='1' ORDER BY open_name_furigana",$connect);
print("東北地方"); while($res01 = mysql_fetch_array($result01,MYSQL_ASSOC)){ if($res01['open_name'] != "" && ($res01['area'] == "青森県"||$res01['area'] == "岩手県"||$res01['area'] == "宮城県"||$res01['area'] == "秋田県"||$res01['area'] == "山形県"||$res01['area'] == "福島県")){ print("【".$res01['area']."】".$res01['open_name']." "); } } print(" | ");
//////////////////////////////
$result01 = mysql_query("select * FROM member WHERE state = '1' && display ='1' ORDER BY open_name_furigana",$connect);
print("関東地方"); while($res01 = mysql_fetch_array($result01,MYSQL_ASSOC)){ if($res01['open_name'] != "" && ($res01['area'] == "茨城県"||$res01['area'] == "栃木県"||$res01['area'] == "群馬県"||$res01['area'] == "埼玉県"||$res01['area'] == "千葉県"||$res01['area'] == "東京都"||$res01['area'] == "神奈川県")){ print("【".$res01['area']."】".$res01['open_name']." "); } } print(" |
中部地方"); while($res01 = mysql_fetch_array($result01,MYSQL_ASSOC)){ if($res01['open_name'] != "" && ($res01['area'] == "山梨県"||$res01['area'] == "長野県"||$res01['area'] == "新潟県"||$res01['area'] == "富山県"||$res01['area'] == "石川県"||$res01['area'] == "福井県"||$res01['area'] == "静岡県"||$res01['area'] == "愛知県"||$res01['area'] == "岐阜県"||$res01['area'] == "三重県")){ print("【".$res01['area']."】".$res01['open_name']." "); } } print(" | ");
//////////////////////////////
$result01 = mysql_query("select * FROM member WHERE state = '1' && display ='1' ORDER BY open_name_furigana",$connect);
print("近畿地方"); while($res01 = mysql_fetch_array($result01,MYSQL_ASSOC)){ if($res01['open_name'] != "" && ($res01['area'] == "滋賀県"||$res01['area'] == "京都府"||$res01['area'] == "大阪府"||$res01['area'] == "兵庫県"||$res01['area'] == "奈良県"||$res01['area'] == "和歌山県")){ print("【".$res01['area']."】".$res01['open_name']." "); } } print(" | ");
//////////////////////////////
$result01 = mysql_query("select * FROM member WHERE state = '1' && display ='1' ORDER BY open_name_furigana",$connect);
print("中国地方"); while($res01 = mysql_fetch_array($result01,MYSQL_ASSOC)){ if($res01['open_name'] != "" && ($res01['area'] == "鳥取県"||$res01['area'] == "島根県"||$res01['area'] == "岡山県"||$res01['area'] == "広島県"||$res01['area'] == "山口県")){ print("【".$res01['area']."】".$res01['open_name']." "); } } print(" |
四国地方"); while($res01 = mysql_fetch_array($result01,MYSQL_ASSOC)){ if($res01['open_name'] != "" && ($res01['area'] == "徳島県"||$res01['area'] == "香川県"||$res01['area'] == "愛媛県"||$res01['area'] == "高知県")){ print("【".$res01['area']."】".$res01['open_name']." "); } } print(" | ");
//////////////////////////////
$result01 = mysql_query("select * FROM member WHERE state = '1' && display ='1' ORDER BY open_name_furigana",$connect);
print("九州地方"); while($res01 = mysql_fetch_array($result01,MYSQL_ASSOC)){ if($res01['open_name'] != "" && ($res01['area'] == "福岡県"||$res01['area'] == "佐賀県"||$res01['area'] == "長崎県"||$res01['area'] == "熊本県"||$res01['area'] == "大分県"||$res01['area'] == "宮崎県"||$res01['area'] == "鹿児島県"||$res01['area'] == "沖縄県")){ print("【".$res01['area']."】".$res01['open_name']." "); } } print(" |