Since 2005.
2004;$J–)
{
// 国内学会
$JJ=$J+1; // $J+1を直接queryコマンドにいれるとエラーになったので。
$query_strings=”SELECT Year,Type,Conference,Authors_jpn,Authors_eng,Title,Invited,City,Country,Start_Month,Start_Day,End_Month,End_Day,Poster,Presentation_Month,Presentation_Day,Comment,URL from Presentation_list where Type=0 and ((Year=”.$JJ.” and Start_Month<4) or (Year=".$J." and Start_Month>3)) order by Year desc,End_Month desc,End_Day desc”;
$result=@mysql_query($query_strings,$link) or die(“クエリ実行エラー”);
$i=mysql_num_rows($result);
if($i>0){
print “
“.$J.”年度
“;
print “
Domestic Conferences
\n”;
$national_conf = 1; // 国内学会があったことを示すフラグ
}
else
{$national_conf = 0;}
while($data=mysql_fetch_assoc($result))
{
echo “\n
“;
echo ““.$i–.’. ‘;
echo $data[‘Title’].”“;
//if($data[‘Invited’]==1)
// { print “(invited)“;}
echo “
\n”;
print “Authors:“.$data[‘Authors_jpn’].”
\n”;
print “Conference:“.$data[‘Conference’].”
\n”;
print “Place:“.$data[‘City’].”, “.$data[‘Country’].”
\n”;
print “Term(month/day):“;
print $data[‘Start_Month’].”/”.$data[‘Start_Day’].”-“.$data[‘End_Month’].”/”.$data[‘End_Day’].”, “.$data[‘Year’].”\nDate of presentation:“.$data[‘Presentation_Month’].”/”.$data[‘Presentation_Day’].”\n”;
if($data[‘URL’] != “”) {print ‘URL‘;}
print “
\n”;
}
// 国際学会
$JJ=$J+1; // $J+1を直接queryコマンドにいれるとエラーになったので。
$query_strings=”SELECT Year,Type,Conference,Authors_jpn,Authors_eng,Title,Invited,City,Country,Start_Month,Start_Day,End_Month,End_Day,Poster,Presentation_Month,Presentation_Day,Comment,URL from Presentation_list where Type=1 and ((Year=”.$JJ.” and Start_Month<4) or (Year=".$J." and Start_Month>3)) order by Year desc, End_Month desc,End_Day desc”;
$result=@mysql_query($query_strings,$link) or die(“クエリ実行エラー”);
$i=mysql_num_rows($result);
if($i>0){
if($national_conf == 0) print “
“.$J.”年度
“;
print “
International Conferences
\n”;
}
while($data=mysql_fetch_assoc($result))
{
echo “\n
“;
echo ““.$i–.’. ‘;
echo $data[‘Title’].”“;
//if($data[‘Invited’]==1)
// { print “(invited)“;}
echo “
\n”;
print “Authors:“.$data[‘Authors_eng’].”
\n”;
print “Conference:“.$data[‘Conference’].”
\n”;
print “Place:“.$data[‘City’].”, “.$data[‘Country’].”
\n”;
print “Term(month/day):“;
print $data[‘Start_Month’].”/”.$data[‘Start_Day’].”-“.$data[‘End_Month’].”/”.$data[‘End_Day’].”, “.$data[‘Year’].”\nDate of presentation:“.$data[‘Presentation_Month’].”/”.$data[‘Presentation_Day’].”\n”;
if($data[‘URL’] != “”) {print ‘URL‘;}
print “
\n”;
}
// echo ‘ページのトップへ‘;
}
mysql_free_result($result);
mysql_close($link) or die(“切断エラー”);
?>