$maxpages || $page < 1){ $page = 1;} $start_row = ($page-1)*$rows_per_page; $newsbyvar = 'News by Topic: '.$newsby; $query = "SELECT id, title, subtitle, publish_date FROM news_topic, news WHERE news_topic.topicid=".$id." AND news.id=news_topic.newsid AND publish_date <= ".$today." ORDER BY publish_date DESC LIMIT " . $start_row . ", " . $rows_per_page; $result = mysql_query($query) or die(mysql_error()); } elseif ($type == 'region') { $query_newsby = "SELECT name FROM region WHERE regionid=".$id; $result_newsby = mysql_query($query_newsby) or die(mysql_error()); $row_newsby = mysql_fetch_assoc ( $result_newsby ); $newsby = $row_newsby['name']; //max number of records needed for next/previous page links $sql = "SELECT * FROM news_region, news WHERE news_region.regionid=".$id." AND news.id=news_region.newsid AND publish_date <= ".$today; $maxresult = mysql_query($sql) or die(mysql_error()); $maxpages = ceil(mysql_num_rows($maxresult) / $rows_per_page); //prevent hacking of page number if ($page > $maxpages || $page < 1){ $page = 1;} $start_row = ($page-1)*$rows_per_page; $newsbyvar = 'News by Region: '.$newsby; $query = "SELECT id, title, subtitle, publish_date, photo1, photo1_cut, audio, video FROM news_region, news WHERE news_region.regionid=".$id." AND news.id=news_region.newsid AND publish_date <= ".$today." ORDER BY publish_date DESC LIMIT " . $start_row . ", " . $rows_per_page; $result = mysql_query($query) or die(mysql_error()); } elseif ($type == 'text') { //max number of records needed for next/previous page links $sql = "SELECT * FROM news WHERE publish_date <= ".$today; $maxresult = mysql_query($sql) or die(mysql_error()); $maxpages = ceil(mysql_num_rows($maxresult) / $rows_per_page); //prevent hacking of page number if ($page > $maxpages || $page < 1){ $page = 1;} $start_row = ($page-1)*$rows_per_page; $newsbyvar = 'All Stories with Text'; $query = "SELECT id, title, subtitle, publish_date, photo1, photo1_cut, audio, video FROM news WHERE publish_date <= ".$today." ORDER BY publish_date DESC LIMIT " . $start_row . ", " . $rows_per_page; $result = mysql_query($query) or die(mysql_error()); } elseif ($type == 'photo') { //max number of records needed for next/previous page links $sql = "SELECT * FROM news WHERE photo1 <> '' AND publish_date <= ".$today; $maxresult = mysql_query($sql) or die(mysql_error()); $maxpages = ceil(mysql_num_rows($maxresult) / $rows_per_page); //prevent hacking of page number if ($page > $maxpages || $page < 1){ $page = 1;} $start_row = ($page-1)*$rows_per_page; $newsbyvar = 'All Stories with Photos'; $query = "SELECT id, title, subtitle, publish_date, photo1, photo1_cut, audio, video FROM news WHERE photo1 <> '' AND publish_date <= ".$today." ORDER BY publish_date DESC LIMIT " . $start_row . ", " . $rows_per_page; $result = mysql_query($query) or die(mysql_error()); } elseif ($type == 'audio') { //max number of records needed for next/previous page links $sql = "SELECT * FROM news WHERE audio <> '' AND publish_date <= ".$today; $maxresult = mysql_query($sql) or die(mysql_error()); $maxpages = ceil(mysql_num_rows($maxresult) / $rows_per_page); //prevent hacking of page number if ($page > $maxpages || $page < 1){ $page = 1;} $start_row = ($page-1)*$rows_per_page; $newsbyvar = 'All Stories with Audio'; $query = "SELECT id, title, subtitle, publish_date, photo1, photo1_cut, audio, video FROM news WHERE audio <> '' AND publish_date <= ".$today." ORDER BY publish_date DESC LIMIT " . $start_row . ", " . $rows_per_page; $result = mysql_query($query) or die(mysql_error()); } elseif ($type == 'video') { //max number of records needed for next/previous page links $sql = "SELECT * FROM news WHERE video <> '' AND publish_date <= ".$today; $maxresult = mysql_query($sql) or die(mysql_error()); $maxpages = ceil(mysql_num_rows($maxresult) / $rows_per_page); //prevent hacking of page number if ($page > $maxpages || $page < 1){ $page = 1;} $start_row = ($page-1)*$rows_per_page; $newsbyvar = 'All Stories with Video'; $query = "SELECT id, title, subtitle, publish_date, photo1, photo1_cut, audio, video FROM news WHERE video <> '' AND publish_date <= ".$today." ORDER BY publish_date DESC LIMIT " . $start_row . ", " . $rows_per_page; $result = mysql_query($query) or die(mysql_error()); } else { //max number of records needed for next/previous page links $sql = "SELECT * FROM news WHERE content <> '' AND publish_date <= ".$today; $maxresult = mysql_query($sql) or die(mysql_error()); $maxpages = ceil(mysql_num_rows($maxresult) / $rows_per_page); //prevent hacking of page number if ($page > $maxpages || $page < 1){ $page = 1;} $start_row = ($page-1)*$rows_per_page; $newsbyvar = 'News by Date'; $query = "SELECT id, title, subtitle, publish_date, photo1, photo1_cut, audio, video FROM news WHERE publish_date <= ".$today." ORDER BY publish_date DESC LIMIT " . $start_row . ", " . $rows_per_page; $result = mysql_query($query) or die(mysql_error()); } echo '

'.$newsbyvar.'

'; while ( $row = mysql_fetch_assoc ( $result ) ) { $id = $row['id']; $title = $row['title']; $subtitle = $row['subtitle']; $publish_date = $row['publish_date']; $photo1 = $row['photo1']; $audio = $row['audio']; $video = $row['video']; $photo1cut = $row['photo1_cut']; $id = stripslashes($id); $title = stripslashes($title); $subtitle = stripslashes($subtitle); $photo1 = stripslashes($photo1); $audio = stripslashes($audio); $video = stripslashes($video); $photo1cut = stripslashes($photo1cut); /* return date to human readable format */ $publish_date = strftime("%B %d, %Y", $publish_date); echo '

'.$publish_date.'
'; if ($photo1 != ""){echo ''.$photo1cut.' ';} echo '

'.$title.'

'; if ($subtitle != "") {echo '
'.$subtitle.'
';} if ($audio != ""){echo 'Audio Icon ';} if ($video != ""){echo 'Video Icon ';} if ($photo1 != ""){echo '
';} echo '
'; } echo '
'; if ($page > 1){ $previouspage = $page - 2; echo '< Previous Page'; } if ($page > 1 && $page < $maxpages){ echo ' | '; } if ($page < $maxpages){ echo ' Next Page >'; } echo '
'; ?>