$Connect_ID = mysql_connect('','dbuser','iKmRA446');
if ( $Connect_ID != $FALSE ) {
mysql_select_db('mydb',$Connect_ID);
mysql_query("set names utf8");
$sql = "SELECT seminor_syousai.seminor_title, seminor_syousai.jissibi, seminor_syousai.from_time, seminor_syousai.to_time, "
."seminor_syousai.place, seminor_syousai.koushi, seminor_syousai.sankou_file, seminor_report.report FROM seminor_syousai "
."left outer join seminor_report on seminor_syousai.seminor_id = seminor_report.seminor_id "
."where seminor_syousai.jissibi < '" .$olddate."' order by seminor_syousai.jissibi desc";
$result = mysql_query($sql, $Connect_ID);
$num_rows = mysql_num_rows($result);
for ($i=0; $i<$num_rows;$i++) {
$r = mysql_fetch_row($result);
echo "
"
.""
."セミナータイトル | "
."" .$r[0]. " | "
."
"
.""
."日時 | "
."" .$r[1]." ".substr($r[2],0,5)."~".substr($r[3],0,5). " | "
."
";
if ($r[4] != "") {
echo""
."場所 | "
."" .$r[4]. " | "
."
";
}
if ($r[5] != "") {
echo""
."講師 | "
."" .$r[5]. " | "
."
";
}
if ($r[6] != "") {
echo""
."参考資料 | "
."資料ダウンロード | "
."
";
}
if ($r[7] != "") {
echo ""
."セミナーレポート | "
."" .$r[7]. " | "
."
";
}
echo"