',c.title,'',' : ',n.headline)
ELSE n.headline
END as news_title
FROM NEWS_ITEMS n
LEFT JOIN MEDIA_CAT_NEWS cn ON n.pKey = cn.news_id
LEFT JOIN MEDIA_CATEGORIES c ON cn.cat_id = c.pKey
UNION ALL
SELECT NULL as user_name,
i.pKey as news_id,
'I' as news_type,
i.interview_text as news_item,
i.date_given as date_added,
DATE_FORMAT(i.date_given,'%M %e, %Y') as news_date,
CONCAT('New Interview: ',i.title) as news_title
from INTERVIEWS i
LEFT JOIN MEDIA_CATEGORIES c on i.film_link = c.pKey
ORDER BY date_added DESC ";
$query_result = @mysql_query($sql,$connection) or die('Could not process SQL because: ' . mysql_error());
$num_rows = mysql_num_rows($query_result);
if (($_GET[start] == "") || ($_GET[start] < $msgs_to_display) || ($_GET[start] > $num_rows)) {
$start_at_msg = "8";
}
else {
$start_at_msg = $_GET[start];
}
$current_msg = "0";
$end_at_msg = $msgs_to_display + $start_at_msg;
?>
Archives of News Updates and Website Updates
For the most recent updates, please visit the main page of this site.
| Currently there are no archives. |
0) {
echo "
Previous Page";
}
if ( ($prev_page > 0) && ($next_page < $num_rows) ) echo " | ";
if ($next_page < $num_rows) {
echo "
Next Page";
}
?>