get_types_as_array();
$ctype = new CType("discipline_id","discipline","disciplines");
$DISCIPLINES=$ctype->get_types_as_array();
//show single news
if ($news_id = $_GET['news_id'])
{
authorization_required($auth->member_id);
show_page_title("News list","",0);
$query = "SELECT * FROM news WHERE news_id=".$news_id;
$rs = $conn->query($query);
if ($conn->num_rows($rs)==0)
{
?>
This news item could not be found. Please follow the links!
fetch_array($rs);
?>
'".$info['post_date']."'
ORDER BY post_date ASC
LIMIT 0,1 ";
$rs = $conn->query($query);
$info_next = $conn->fetch_array($rs);
$query = "SELECT news_id AS prev_news_id
FROM news
WHERE post_date < '".$info['post_date']."'
ORDER BY post_date DESC
LIMIT 0,1 ";
$rs = $conn->query($query);
$info_prev = $conn->fetch_array($rs);
?>
NOW()";
$archive_link = 'query($query);
$total_arr = $conn->fetch_array($rs);
$total_records = $total_arr[0];
$pag=new CPaging($_GET,$news_on_page,$total_records);
//select all non-archived news
$query = "SELECT *
FROM news
$where_clause
ORDER BY priority,post_date DESC
".$pag->sql_page_limit();
$rs = $conn->query ($query);
if ($conn->num_rows($rs)==0)
{
?>
Page display_pages() ?>