●現在登録されているマッチメイクを、新しい順に、表示しています。
|
| 試合日 |
時間 |
主催チーム |
レベル |
コメント |
申込 |
編集 |
登録日時 |
= $today or date = \"\") ";
if (!empty($sql_and)) {
$sql .= $sql_and;
}
$sql .= "order by match_make_id desc ";
$sql .= "limit $sid, $DISP_ROW_COUNT ";
#echo "sql: $sql
\n";
$result = mysql_query($sql)
or error(__FILE__, __LINE__, "Database Error", "$sql", true);
while (list(
$match_make_id, $sisetu_key,
$team_name, $kaiin_kubun, $kaiin_id, $leader_name, $level,
$date, $youbi, $start_time, $end_time,
$comment, $email, $password,
$create_time, $update_time
) = mysql_fetch_row($result)) {
$level_ = "";
$level_ = $level;
$date_ = "";
if (!empty($date)) {
$date_Y = substr($date, 0, 4);
$date_m = substr($date, 4, 2);
$date_d = substr($date, 6, 2);
if ((!empty($date_Y)) and (!empty($date_m)) and (!empty($date_d))) {
$date_ = $date_Y . "
" . $date_m . "/" . $date_d;
} else {
$date_ = $date_Y . $date_m . $date_d;
}
}
$time_ = "";
$start_time_hh = substr($start_time, 0, 2);
$start_time_mm = substr($start_time, 2, 2);
$end_time_hh = substr($end_time, 0, 2);
$end_time_mm = substr($end_time, 2, 2);
if ((!empty($start_time_hh)) and (!empty($start_time_mm)) and (!empty($end_time_hh)) and (!empty($end_time_mm))) {
$time_ = $start_time_hh . ":" . $start_time_mm . "〜" . $end_time_hh . ":" . $end_time_mm;
} else {
$time_ = $start_time_hh . $start_time_mm . " " . $end_time_hh . $end_time_mm;
}
# 詳細、編集ページURL設定
$update_url = "match_form.php?mode=update&mid=$match_make_id";
#echo "create_time: $create_time
";
$create_time_ = get_datetime_str($create_time);
echo " \n";
echo " | $date_ | \n";
echo " $time_ | \n";
echo " $team_name | \n";
echo " $level_ | \n";
echo " $comment | \n";
echo " 申込 | \n";
echo " 編集 | \n";
echo " $create_time_ | \n";
echo " \n";
}
?>
|
|
|