\n"; //records $sql = "SELECT * FROM records WHERE articleId='".$_GET['articleId']."'"; $result = mysql_query($sql); $row1 = mysql_fetch_array($result,MYSQL_ASSOC);//row1 mysql_free_result($result); //作者 $sql = "SELECT * FROM authors WHERE articleId='".$row1['articleId']."'"; $result = mysql_query($sql); $row2 = mysql_fetch_array($result,MYSQL_ASSOC);//row2 mysql_free_result($result); //關鍵字 $sql = "SELECT * from keywords WHERE articleId='".$row1['articleId']."'"; $result = mysql_query($sql); //echo $sql; $row3 = mysql_fetch_array($result,MYSQL_ASSOC);//row3 mysql_free_result($result); //卷期 $sql = "SELECT * FROM volumeissue WHERE volumeAndIssueId='".$row1['volumeAndIssueId']."'"; $result = mysql_query($sql); $row4 = mysql_fetch_array($result,MYSQL_ASSOC);//row4 mysql_free_result($result); //language $s_lang="SELECT iso_639_2b FROM languages JOIN records ON records.languageId = languages.languageId WHERE articleId ='".$row1['articleId']."'"; $r_lang= mysql_query($s_lang); $row5 = mysql_fetch_array($r_lang,MYSQL_ASSOC);//row5 mysql_free_result($r_lang); ?> Tamkang University Press Journal of Educational Media and Library Sciences 1013-090X " . $row1['doi'] ."" ?> Research Article Brief Communication Book Review Observation Report Editoral <? echo $row1['chiTitle']?> <? echo addslashes($row1['engTitle']); ?> http://joemls.dils.tku.edu.tw/fulltext//-/-.pdf