include("../dbconn/dbconn2.php"); //create $conntect and use `board` database
include("../dbconn/str_func.php");
$view_count=3;
//Headline News (Notice KCP)
$sql = "SELECT * FROM issue$table_lang_suffix ORDER BY no DESC LIMIT 0,$view_count";
$records_news = mysql_query($sql,$connect);
//School Life News (Fasion KCP)
$sql = "SELECT * FROM notice$table_lang_suffix ORDER BY no DESC LIMIT 0,$view_count";
$records_school = mysql_query($sql,$connect);
//Part Time Job
$sql = "SELECT * FROM part_time_job$table_lang_suffix ORDER BY no DESC LIMIT 0,$view_count";
$records_job = mysql_query($sql,$connect);
//Living
$sql = "SELECT * FROM living$table_lang_suffix ORDER BY no DESC LIMIT 0,$view_count";
$records_living = mysql_query($sql,$connect);
//Album
$sql = "SELECT * FROM gallery$table_lang_suffix ORDER BY no DESC LIMIT 0,$view_count";
$records_gallery = mysql_query($sql,$connect);
$album_count = 0;
while ($row = mysql_fetch_assoc($records_gallery)) {
$album_no[$album_count] = $row['no'];
$album_title[$album_count] = $row['subject'];
$album_address[$album_count] = $row['upload_path1'];
$album_count++;
}
?>