numRows()>0) { $result->fetchInto($row, DB_FETCHMODE_ASSOC); $PREF_NAME = mb_convert_encoding( $row['PREF_NAME'],"SJIS", "EUC-JP,auto") ; } //SQL実行//マスタデータは常にSELECT $sql = "select distinct I.CITY_NAME from T_JYANRU AS A "; $sql .= " INNER JOIN T_SHOP AS B ON (A.ID = B.ID)"; $sql .= " LEFT JOIN M_JYANRU_S AS C ON (A.JYANRU_CD =C.JYANRU_CD AND A.JYANRU_S_CD =C.JYANRU_S_CD )"; $sql .= " INNER JOIN M_KEISAISYA AS G ON B.ID=G.ID"; $sql .= " INNER JOIN M_PREF AS H ON B.PREF_CD=H.PREF_CD"; $sql .= " INNER JOIN M_CITY AS I ON B.PREF_CD=I.PREF_CD AND B.CITY_CD=I.CITY_CD"; $sql .= " WHERE "; $sql .= " B.PREF_CD = " . $PREF_CD; //掲載期限 $sql .= " AND date_format(now(),'%Y-%m-%d') BETWEEN date_format(G.START_DATE,'%Y-%m-%d') AND date_format(G.END_DATE,'%Y-%m-%d')"; $sql .= " AND (G.DEL_FLG<>'1' OR G.DEL_FLG IS NULL)"; $sql .= " AND G.FLG<>'9'"; $sql .= " ORDER BY B.CITY_CD"; $result=db_select($db,$sql); while($result->fetchInto($row, DB_FETCHMODE_ASSOC)) { $CITY_NAME .= mb_convert_encoding( $row['CITY_NAME'],"SJIS", "EUC-JP,auto") .","; } $CITY_NAME = substr($CITY_NAME,0,strlen($CITY_NAME)-1); //SQL実行//マスタデータは常にSELECT $sql = "select distinct A.JYANRU_CD,B.JYANRU_NAME from T_JYANRU AS A "; $sql .= " LEFT JOIN M_JYANRU AS B ON A.JYANRU_CD =B.JYANRU_CD "; $sql .= " INNER JOIN T_SHOP AS C ON (A.ID = C.ID)"; $sql .= " INNER JOIN M_KEISAISYA AS G ON C.ID=G.ID"; $sql .= " WHERE "; $sql .= " C.PREF_CD = " . $PREF_CD; //掲載期限 $sql .= " AND date_format(now(),'%Y-%m-%d') BETWEEN date_format(G.START_DATE,'%Y-%m-%d') AND date_format(G.END_DATE,'%Y-%m-%d')"; $sql .= " AND (G.DEL_FLG<>'1' OR G.DEL_FLG IS NULL)"; $sql .= " AND G.FLG<>'9'"; $sql .= " ORDER BY A.JYANRU_CD"; $result=db_select($db,$sql); $TEMP_LIST=""; while($result->fetchInto($row, DB_FETCHMODE_ASSOC)) { $array1[] = mb_convert_encoding( $row['JYANRU_CD'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['JYANRU_NAME'],"SJIS", "EUC-JP,auto") ; $TEMP_LIST .= mb_convert_encoding( $row['JYANRU_NAME'],"SJIS", "EUC-JP,auto") .","; } $TEMP_LIST = substr($TEMP_LIST,0,strlen($TEMP_LIST)-1); //SQL実行//マスタデータは常にSELECT $sql = "select distinct A.JYANRU_CD,D.JYANRU_S_NAME from T_JYANRU AS A "; $sql .= " LEFT JOIN M_JYANRU AS B ON A.JYANRU_CD =B.JYANRU_CD "; $sql .= " INNER JOIN T_SHOP AS C ON (A.ID = C.ID)"; $sql .= " LEFT JOIN M_JYANRU_S AS D ON A.JYANRU_CD =D.JYANRU_CD AND A.JYANRU_S_CD =D.JYANRU_S_CD "; $sql .= " INNER JOIN M_KEISAISYA AS G ON C.ID=G.ID"; $sql .= " WHERE "; $sql .= " C.PREF_CD = " . $PREF_CD; //掲載期限 $sql .= " AND date_format(now(),'%Y-%m-%d') BETWEEN date_format(G.START_DATE,'%Y-%m-%d') AND date_format(G.END_DATE,'%Y-%m-%d')"; $sql .= " AND (G.DEL_FLG<>'1' OR G.DEL_FLG IS NULL)"; $sql .= " AND G.FLG<>'9'"; $sql .= " ORDER BY A.JYANRU_CD"; $result=db_select($db,$sql); //$TEMP_LIST=""; while($result->fetchInto($row, DB_FETCHMODE_ASSOC)) { $array2[] = mb_convert_encoding( $row['JYANRU_CD'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['JYANRU_S_NAME'],"SJIS", "EUC-JP,auto") ; //$TEMP_LIST .= mb_convert_encoding( $row['JYANRU_NAME'],"SJIS", "EUC-JP,auto") .","; } //$TEMP_LIST = substr($TEMP_LIST,0,strlen($TEMP_LIST)-1); //SQL実行//マスタデータは常にSELECT $sql = "select * from T_URANAI "; $sql .= " WHERE "; //掲載期限 $sql .= " date_format(now(),'%Y-%m-%d') BETWEEN date_format(U_START_DATE,'%Y-%m-%d') AND date_format(U_END_DATE,'%Y-%m-%d')"; $sql .= " ORDER BY ID"; $result=db_select($db,$sql); //$TEMP_LIST=""; while($result->fetchInto($row, DB_FETCHMODE_ASSOC)) { $array_uranai[] = mb_convert_encoding( $row['ID'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_MONTH'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_HOSINAME'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_UN'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_TITLE_1'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_COMMENT_1'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_TITLE_2'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_COMMENT_2'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_TITLE_3'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_COMMENT_3'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_TITLE_4'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_COMMENT_4'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_TITLE_5'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_COMMENT_5'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_TITLE_6'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_COMMENT_6'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_TITLE_7'],"SJIS", "EUC-JP,auto"). "\t" . mb_convert_encoding( $row['URANAI_COMMENT_7'],"SJIS", "EUC-JP,auto"); } //$TEMP_LIST = substr($TEMP_LIST,0,strlen($TEMP_LIST)-1); db_disconnect($db,$result); ?> "; ?> こかナビ | 青柳妙英先生の占い | 九星気学
こかナビ
point 青柳妙英先生の九星気学
line 今月もあなたの運勢を九星気学(きゅうせいきがく)でズバリ!!
line 占いの見方はこちらから line
line point サイトマップ
point 友達に教える
point お問合わせ
point ホームへ戻る
情報ポータル
『こかナビ』