include( "../../../lib/ticketlib.phtml" ) ?> include( "../../../lib/navilib.phtml" ) ?> include( "../../../lib/listlib.phtml" ) ?> include( "../../../lib/getlib.phtml" ) ?> $now_year = sprintf ( "%04d", $now_year ) ; $now_month = sprintf ( "%02d", $now_month ) ; $now_day = sprintf ( "%02d", $now_day ) ; $dep_date = $now_year."/".$now_month."/".$now_day ; /*---< DBコネクト >---*/ $conn = db_connect($db_connect_str) ; if ( !$conn ) { exit ; } /*---< TOPページ設定 >---*/ if ( strlen ( $agent ) > 0 ) { $top_page = get_agent_url ( $conn, $agent ) ; $top_page = "http://".$top_page ; } /*---< チケットテーブル検索 >---*/ $sql_cmd = "SELECT * FROM TOUR_TICKET WHERE " ; $sql_cmd = $sql_cmd."TOUR_CD = '$tour_cd'" ; $result = pg_Exec ( $conn, $sql_cmd ) ; if ( !$result ) { pg_FreeResult ( $result ) ; pg_Close ( $conn ) ; exit (); } $res_num = pg_NumRows ( $result ) ; if ( $res_num > 0 ) { $tour_name = pg_Result ( $result, 0, "tour_name" ) ; $tour_sub = pg_Result ( $result, 0, "tour_sub" ) ; $recom_flg = pg_Result ( $result, 0, "recom_flg" ) ; } ?>