1999;$J–)
{
print ‘

---

‘.$J.” 年

\n”;

// Original papers

// $JJ=$J+1; 年度の場合(2009年以前のデーターは出版日の登録がないため保留）
//
// $query_strings=”SELECT Title,Author_Eng,Author_Japanese,Journal,Volume,Page_start,Page_end,Year,Published_Month,DOI,Registrate_Date FROM Publication_list where Classification=’Original Papers’ and ((Year=”.$JJ.” and Published_Month <4) or (Year=".$J." and Published_Month >3)) order by Year desc, Published_Month desc”;

$query_strings=”SELECT Title,Author_Eng,Author_Japanese,Journal,Volume,Page_start,Page_end,Year,Published_Month,DOI,Registrate_Date FROM Publication_list where Classification=’Original Papers’ and Year=”.$J.” order by Year desc, Published_Month desc”;

$result=@mysql_query($query_strings,$link) or die(“クエリ実行エラー”);

$i=mysql_num_rows($result);

if($i != 0) {print “\n

Original Papers

\n”;}

while($data=mysql_fetch_assoc($result))
{
echo “\n

“;
echo ““.$i–.’. ‘;
echo $data[‘Title’].”
\n”;
if($data[‘Author_Japanese’] !=NULL) {
print $data[‘Author_Japanese’].”
\n”;
}
else
{
print $data[‘Author_Eng’].”
\n”;
}
print ““.$data[‘Journal’].”,”.”“.$data[‘Volume’].”,”.$data[‘Page_start’].”-“.$data[‘Page_end’].”,”.$data[‘Year’].”
\n”;
print ‘DOI: ‘.$data[‘DOI’].”\n”;
print “

\n”;
}

// Proceedings

// $JJ=$J+1; 年度
// $query_strings=”SELECT Title,Author_Eng,Author_Japanese,Journal,Volume,Page_start,Page_end,Year,Published_Month,DOI FROM Publication_list where Classification=’Proceedings’ and ((Year=”.$JJ.” and Published_Month <4) or (Year=".$J." and Published_Month >3)) order by Year desc, Published_Month desc”;

$query_strings=”SELECT Title,Author_Eng,Author_Japanese,Journal,Volume,Page_start,Page_end,Year,Published_Month,DOI FROM Publication_list where Classification=’Proceedings’ and Year=”.$J.” order by Year desc, Published_Month desc”;

$result=@mysql_query($query_strings,$link) or die(“クエリ実行エラー”);

$i=mysql_num_rows($result);

if($i != 0) { print “\n

Proceedings

\n”;}

while($data=mysql_fetch_assoc($result))
{
echo “\n

“;
echo ““.$i–.’. ‘;
echo $data[‘Title’].”
\n”;
print $data[‘Author_Eng’].”
\n”;
print ““.$data[‘Journal’].”,”.”“.$data[‘Volume’].”,”.$data[‘Page_start’].”-“.$data[‘Page_end’].”,”.$data[‘Year’].”
\n”;
print ‘DOI: ‘.$data[‘DOI’].”\n”;
print “

\n”;
}

// Review and Books

// $JJ = $J+1; 年度にする場合

// $query_strings=”SELECT Title,Author_Eng,Author_Japanese,Journal,Volume,Page_start,Page_end,Year,Published_Month,DOI FROM Publication_list where Classification=’Reviews/Books’ and ((Year=”.$JJ.” and Published_Month <4) or (Year=".$J." and Published_Month >3)) order by Year desc, Published_Month desc”;

$query_strings=”SELECT Title,Author_Eng,Author_Japanese,Journal,Volume,Page_start,Page_end,Year,Published_Month,DOI FROM Publication_list where Classification=’Reviews/Books’ and Year=”.$J.” order by Year desc, Published_Month desc”;
$result=@mysql_query($query_strings,$link) or die(“クエリ実行エラー”);

$i=mysql_num_rows($result);

if($i > 0) { print “\n

Reviews/Books

\n”;}
while($data=mysql_fetch_assoc($result))
{
echo “\n

“;
echo ““.$i–.’. ‘;
echo $data[‘Title’].”
\n”;
if($data[‘Author_Japanese’]) {
print $data[‘Author_Japanese’].”
\n”;
}
else
{
print $data[‘Author_Eng’].”
\n”;
}
print ““.$data[‘Journal’].”,”.”“.$data[‘Volume’].”,”.$data[‘Page_start’].”-“.$data[‘Page_end’].”,”.$data[‘Year’].”
\n”;
print ‘DOI: ‘.$data[‘DOI’].”\n”;
print “

\n”;
}

echo ‘ページのトップへ‘;

}

mysql_free_result($result);
mysql_close($link) or die(“切断エラー”);

?>