0)
{
foreach ($ids_arr as $v)
{
$nid = (int)$v;
DeleteNews($nid);
}
header("Location: news.php?msg=deleted");
exit();
}
}
////////////////// filter //////////////////////
if (isset($_GET['column']) && $_GET['column'] != "")
{
switch ($_GET['column'])
{
case "news_id": $rrorder = "news_id"; break;
case "added": $rrorder = "added"; break;
case "modified": $rrorder = "modified"; break;
case "status": $rrorder = "status"; break;
default: $rrorder = "news_id"; break;
}
}
else
{
$rrorder = "news_id";
}
if (isset($_GET['order']) && $_GET['order'] != "")
{
switch ($_GET['order'])
{
case "asc": $rorder = "asc"; break;
case "desc": $rorder = "desc"; break;
default: $rorder = "desc"; break;
}
}
else
{
$rorder = "desc";
}
///////////////////////////////////////////////////////
if (isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0) { $page = (int)$_GET['page']; } else { $page = 1; }
$from = ($page-1)*$results_per_page;
$query = "SELECT *, DATE_FORMAT(added, '".DATE_FORMAT." %h:%i %p') AS news_date FROM exchangerix_news ORDER BY $rrorder $rorder LIMIT $from, $results_per_page";
$total_result = smart_mysql_query("SELECT * FROM exchangerix_news ORDER BY news_title ASC");
$total = mysqli_num_rows($total_result);
$result = smart_mysql_query($query);
$total_on_page = mysqli_num_rows($result);
$cc = 0;
$title = "News";
require_once ("inc/header.inc.php");
?>
News
0) { ?>
There are no news at this time.