発表

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(“切断エラー”);
?>

Comments are closed.