"; include("biyou_menu.inc"); print "

\n"; $check_flag=0; if ($yomi == "01"){ print "あ行 "; $check_flag=1; }else{ print "あ行 "; } if ($yomi == "11"){ print "か行 "; $check_flag=1; }else{ print "か行 "; } if ($yomi == "21"){ print "さ行 "; $check_flag=1; }else{ print "さ行 "; } if ($yomi == "31"){ print "た行 "; $check_flag=1; }else{ print "た行 "; } if ($yomi == "41"){ print "な行
"; $check_flag=1; }else{ print "な行
"; } if ($yomi == "51"){ print "は行 "; $check_flag=1; }else{ print "は行 "; } if ($yomi == "61"){ print "ま行 "; $check_flag=1; }else{ print "ま行 "; } if ($yomi == "71"){ print "や行 "; $check_flag=1; }else{ print "や行 "; } if ($yomi == "81"){ print "ら行 "; $check_flag=1; }else{ print "ら行 "; } if ($yomi == "91"){ print "わ行"; $check_flag=1; }else{ print "わ行"; } print "

\n"; print "

\n"; $sql = "select * from biyou_info where chk='1'"; if ($check_flag == "1"){ switch($yomi){ case "01" : $sql .= " and furigana in ('1','2','3','4','5','01','02','03','04','05')"; break; case "11" : $sql .= " and furigana in ('11','12','13','14','15')"; break; case "21" : $sql .= " and furigana in ('21','22','23','24','25')"; break; case "31" : $sql .= " and furigana in ('31','32','33','34','35')"; break; case "41" : $sql .= " and furigana in ('41','42','43','44','45')"; break; case "51" : $sql .= " and furigana in ('51','52','53','54','55')"; break; case "61" : $sql .= " and furigana in ('61','62','63','64','65')"; break; case "71" : $sql .= " and furigana in ('71','72','73','74','75')"; break; case "81" : $sql .= " and furigana in ('81','82','83','84','85')"; break; case "91" : $sql .= " and furigana in ('91','92','93','94','95')"; break; } } if ($yomi == ""){ $sql .= " and furigana in ('1','2','3','4','5','01','02','03','04','05')"; } $sql .= " order by furigana"; $database = pg_connect("dbname=mall"); pg_set_client_encoding($database,"SJIS"); $result = pg_exec ($database,"$sql"); $rows = pg_numrows($result); for ($i=0;$i<$rows;$i++){ $arr = pg_fetch_array($result,$i); $shop_no[$i] = $arr["shop_no"]; $shopname[$i] = $arr["shopname"]; $name[$i] = $arr["$name"]; $zip[$i] = $arr["zip"]; $address[$i] = $arr["address"]; $tel_no[$i] = $arr["tel_no"]; $fax_no[$i] = $arr["fax_no"]; $url[$i] = $arr["url"]; $mail[$i] = $arr["mail"]; $holiday[$i] = $arr["holiday"]; $start_time[$i] = $arr["start_time"]; $end_time[$i] = $arr["end_time"]; $area_code[$i] = $arr["area"]; $street[$i] = $arr["street"]; $cut[$i] = $arr["cut"]; $map_code[$i] = $arr["map_code"]; $map_big[$i] = $arr["map_big"]; $map_no[$i] = $arr["map_no"]; $type[$i] = $arr["type"]; $ticket[$i] = $arr["ticket"]; $ticket_info[$i] = $arr["ticket_info"]; $touroku_date[$i] = $arr["touroku_date"]; $koushin_date[$i] = $arr["koushin_date"]; $tmp1[$i] = $arr["tmp1"]; } pg_freeresult($result); pg_close($database); // print "$sql
\n"; $color[0] = "#FFDAB9"; $color[1] = "#FFCCFF"; print "


\n"; print "掲載を希望しない美容室は表示されません。

\n"; print "情報の変更等がある場合はが〜て・ながおか事務局までご連絡ください。

\n"; print "

\"マップを表示します\"・・・マップを表示します。
\"詳細マップを表示します\"・・・詳細マップを表示します。
\"美容院のホームページを表示します\"・・・美容院のホームページを表示します。
\"美容院へメールを送ります\"・・・美容院へメールを送ります。

\n"; print "\n"; $c_chk = 0; for ($i=0;$i<$rows;$i++){ print "\n\n\n\n\n\n\n\n\n\n\n\n\n\n"; print "\n"; if ($c_chk == 0){ $c_chk = 1; }else{ $c_chk =0; } } print "
"; if ($type[$i] == "1"){print "\"予約できます\"";}else{print "
";} print "
"; if ($map_code[$i] != "00"){print "\"マップを表示します\"";}else{print "
";} print "
"; if ($map_big[$i] != "000"){print "\"詳細マップを表示します\"";}else{print "
";} print "
"; if ($url[$i] != ""){ print "$shopname[$i]"; }else{ print "$shopname[$i]"; } print ""; if ($start_time[$i] != ""){print "営業時間 $start_time[$i]〜$end_time[$i]";}else{print "
";} print "
"; print "$address[$i]"; print "

"; if ($url[$i] != ""){print "\"お店のホームページを表示します\"";}else{print "
";} print "
"; if ($mail[$i] != ""){print "\"お店へメールを送ります\"";}else{print "
";} print "

"; print "TEL:$tel_no[$i]"; if ($tmp1[$i] != ""){print " 備考:$tmp1[$i]";} print "
\n"; include("footer.inc"); print ""; } ?>