Block("DATA");
$sql = "SELECT * FROM $db_table_cornerinterest $other_sql ORDER BY INTEREST_NO DESC limit $start_loop,$cfg_list_per_page";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
$interest_no = $row[interest_no];
if ($bgcolor == "#F9F9F9") { $bgcolor = "#FFFFF9"; }
else { $bgcolor = "#F9F9F9"; }
# $sql1 = "SELECT * FROM $db_table_cornerinterest_category WHERE CATEGORY_INTEREST_NO = '$row[CATEGORY_INTEREST_NO]'";
# $result1 = mysql_query($sql1);
# while($row1 = mysql_fetch_array($result1)) {
# $category_name = $row1[CATEGORY_NAME];
# }
# mysql_free_result($result1);
$interest_no = $row[INTEREST_NO];
# $news_name = $row[INTEREST_NAME];
# if ($keyword) {
# $news_name = preg_replace("/$keyword/", "$keyword", $news_name);
# }
/*
echo "";
print_r($row1);
echo "
";
*/
$data = array(
'bgcolor' => $bgcolor,
'news_id' => $interest_no,
'news_name' => $row[interest_name],
'category_name' => $category_name,
'news_date_add' => Convert_YMDHMS_2_DMYHM_Name($row[interest_created_date]),
'news_detail' => $row[interest_detail],
'news_url' => $row[interest_url],
);
$tp->Apply($data);
}
mysql_free_result($result);
# /Split Page
$select_category_id = "\n";
$sql = "SELECT * FROM $db_table_cornerinterest_category ORDER BY category_interest_no";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
$selected = "";
if ($category_id == $row[category_interest_no]) { $selected = "selected"; }
$cat_name = $row[category_name];
$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 ####
?>