Block("DATA");
$sql = "SELECT * FROM $db_table_news $other_sql ORDER BY NEWS_ID DESC limit $start_loop,$cfg_list_per_page";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
if ($bgcolor == "#F9F9F9") { $bgcolor = "#FFFFF9"; }
else { $bgcolor = "#F9F9F9"; }
$sql1 = "SELECT * FROM $db_table_news_category WHERE CATEGORY_ID = '$row[CATEGORY_ID]'";
$result1 = mysql_query($sql1);
while($row1 = mysql_fetch_array($result1)) {
$category_name = $row1[CATEGORY_NAME];
}
mysql_free_result($result1);
$news_name = $row[NEWS_NAME];
if ($keyword) {
$news_name = preg_replace("/$keyword/", "$keyword", $news_name);
}
$data = array(
'bgcolor' => $bgcolor,
'news_id' => $row[NEWS_ID],
'news_name' => $news_name,
'category_name' => $category_name,
'news_date_add' => Convert_YMDHMS_2_DMYHM_Name($row[NEWS_DATE_ADD]),
);
$tp->Apply($data);
}
mysql_free_result($result);
# /Split Page
$select_category_id = "\n";
$sql = "SELECT * FROM $db_table_news_category ORDER BY CATEGORY_NAME";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
$selected = "";
if ($category_id == $row[CATEGORY_ID]) { $selected = "selected"; }
$select_category_id .= "\n";
}
mysql_free_result($result);
mysql_close($db);
$tp->Mix();
$HTML = $tp->Data();
$HTML = preg_replace("/\\$(\w+)/e","$$1",$HTML);
echo $HTML;
exit;
ob_end_flush();
#### end of program ####
#####################################################################
#### Start sub program. Don't touch anything below ####
?>