\n"; if ($data) { while($each = mysql_fetch_array($data)) { echo "\n ". mb_convert_encoding($each[v_title], 'UTF-8', 'ISO-8859-1') ."\n\n"; } } echo "
\n"; $link = mysql_connect($db_server, $db_username, $db_password); mysql_select_db($db_name); ?>

  \n"; if ($data) { while($each = mysql_fetch_array($data)) { echo "\n ". $each[subject] ." - ". $each[name] ."\n\n"; } } echo "
\n"; $link = mysql_connect($db_server, $db_username, $db_password); mysql_select_db($db_name); ?>

 \n"; if ($data) { while($each = mysql_fetch_array($data)) { $getauthor = mysql_query("SELECT $tb_author.AuthorID, $tb_author.Authorname FROM $tb_author, $tb_subject_authors_vietsuca WHERE $tb_subject_authors_vietsuca.AuthorID=$tb_author.AuthorID AND $tb_subject_authors_vietsuca.SubjectID='".$each[SubjectID]."'"); $author=""; while ($row = mysql_fetch_array($getauthor, MYSQL_NUM)) { $author .= trim($row[1]) . ", "; } $author = substr($author,0,strlen($author)-2); echo "\n ".$each[Subjectname]." - ". $author."\n\n"; } } echo "
\n"; $link = mysql_connect($db_server, $db_username, $db_password); mysql_select_db($db_name); ?>

 \n"; if ($data) { while($each = mysql_fetch_array($data)) { $getauthor = mysql_query("SELECT $tb_author.AuthorID, $tb_author.Authorname FROM $tb_author, $tb_subject_authors_vietsuca WHERE $tb_subject_authors_vietsuca.AuthorID=$tb_author.AuthorID AND $tb_subject_authors_vietsuca.SubjectID='".$each[SubjectID]."'"); $author=""; while ($row = mysql_fetch_array($getauthor, MYSQL_NUM)) { $author .= trim($row[1]) . ", "; } $author = substr($author,0,strlen($author)-2); echo "\n ".$each[Subjectname]." - ". $author."\n\n"; } } echo "
\n"; $link = mysql_connect($db_server, $db_username, $db_password); mysql_select_db($db_name); ?>