{$event_title}|{$comp_name}|楽器フェア"; ?>

イベント紹介

{$event_promo}\n"; } //event_idがminimumのフォルダから画像を取得 ///データベース接続 $db = db_connect(); if ($db == false){ print mb_convert_encoding("db接続に失敗しました", $disp_enc, $dest_enc); die; } //SQL $str_sql = "select min(event_id) event_img_id from T_EVENT "; $str_sql = $str_sql . " where EVENT_TITLE="; $str_sql = $str_sql . "(SELECT EVENT_TITLE FROM T_EVENT WHERE COMP_ID = '" . $comp_id . "' AND EVENT_ID = '" . $event_id . "')"; // SQL文の実行 if (sql_select($str_sql , $cnt , $row, "SET NAMES ujis;",$db) == false){ print mb_convert_encoding("SQL実行時にエラー:" .$str_sql , $disp_enc, $dest_enc); db_disconnect($db); die; } if( $cnt != 0 ) { $event_img_id = mb_convert_encoding($row["event_img_id"], $disp_enc, $dest_enc); } //DB切断 db_disconnect($db); if($event_obj != ""){ print "\"\"\n"; } ?>

日時:\n"; print "
"; while ($date_row = mysql_fetch_array($date_rs, MYSQL_ASSOC)) { $event_open_time = mb_convert_encoding($date_row["EVENT_OPEN_HHMI"], $disp_enc, $dest_enc); $event_start_time = mb_convert_encoding($date_row["EVENT_START_HHMI"], $disp_enc, $dest_enc); $event_end_time = mb_convert_encoding($date_row["EVENT_END_HHMI"], $disp_enc, $dest_enc); $event_date = mb_convert_encoding($date_row["EVENT_DATE"], $disp_enc, $dest_enc); $event_week = $date_row["EVENT_WEEK"]; print "{$event_date}({$event_week}) {$event_start_time}~{$event_end_time} 開場 :{$event_open_time}
\n"; } print "
\n"; //DB切断 db_disconnect($db); print "
整理券:
\n"; switch ($event_seiri) { case "1": print "
有り
"; break; case "0": print "
無し
"; break; default: break; } if ($place_name != "") { print "
場所:
\n"; if ($event_place_id == "99") { print "
{$place_name}({$comp_boothno})
\n"; }else { print "
{$place_name}
\n"; } } if ($event_appea != "") { print "
出演:
"; print "
{$event_appea}
\n"; } ?>

提供

{$comp_name}\n"; } //登録されていない場合は項目ごと表示しない if ($event_support != "") { print "

協賛

\n"; print "

{$event_support}

\n"; } if ($comp_post != "" or $comp_address != "" or $comp_tel != "" or $comp_mail != "" or $comp_url != "" or $comp_url2 != "" or $comp_url3 != "") { print "

お問い合わせ

\n"; } if ($comp_post != "") { print "

〒{$comp_post}

\n"; } if ($comp_address != "") { print "

{$comp_address}

\n"; } if ($comp_tel != "") { print "

Tel : {$comp_tel}

\n"; } if ($comp_mail != "") { print "

Email : {$comp_mail}

\n"; } if ($comp_url != "") { print "

Web1 : {$comp_url}

\n"; } if ($comp_url2 != "") { print "

Web2 : {$comp_url2}

\n"; } if ($comp_url3 != "") { print "

Web3 : {$comp_url3}

\n"; } ?>