include("admin/dbconnect.php");
$result5 = mysql_query("SELECT * FROM info WHERE info_id=1")
or die(mysql_error());
// loop through results of database query, displaying them in the table
while($row = mysql_fetch_array( $result5 )) {
$info_news_items = $row['info_news_items'];
}
// get results from database
$result = mysql_query("SELECT * FROM news WHERE ser_archive != 'X' ORDER BY ser_date DESC, ser_category, ser_title")
or die(mysql_error());
echo "( ";
$total_results = mysql_num_rows($result);
if ($info_news_items == 0 )
{
$per_page = "6"; //limit of archived results per page.
} else {
$per_page = $info_news_items; //limit of archived results per page.
}
$total_pages = ceil($total_results / $per_page); //total number of pages
// This is the beginning of the Previous/Next Navigation
if (isset($_GET['page']) && is_numeric($_GET['page']))
{
$show_page = $_GET['page'];
// make sure the $show_page value is valid
if ($show_page > 0 && $show_page <= $total_pages)
{
$start = ($show_page -1) * $per_page;
$end = $start + $per_page;
}
else
{
// error - show first set of results
$start = 0;
$end = $per_page;
}
}
else
{
// if page isn't set, show first set of results
$start = 0;
$end = $per_page;
$show_page =1;
}
echo $total_results;
echo " found ) Page $show_page of $total_pages";
echo "
";
echo "
";
echo "
";
if ($show_page > 1)
{
$page = $show_page-1;
echo " ";
}
if($show_page != $total_pages || $show_page == 0 && $total_pages >= 2)
{
$page = $show_page+1;
echo " ";
}
echo "";
echo "
";
echo "
";
echo "
";
// loop through results of database query, displaying them in the table
for ($i = $start; $i < $end; $i++)
{
// make sure that PHP doesn't try to show results that don't exist
if ($i == $total_results) { break; }
$urllink = mysql_result($result, $i, 'ser_url');
$ser_image1 = mysql_result($result, $i, 'ser_image1');
$ser_title = mysql_result($result, $i, 'ser_title');
$ser_seo_title = mysql_result($result, $i, 'ser_seo_title');
$ser_category = mysql_result($result, $i, 'ser_category');
$ser_title=stripslashes($ser_title);
$ser_seo_title=stripslashes($ser_seo_title);
$ser_video_title = mysql_result($result, $i, 'ser_video_title');
$ser_video_link = mysql_result($result, $i, 'ser_video_link');
$ser_video_title=stripslashes($ser_video_title);
$ser_video_link=stripslashes($ser_video_link);
$pdf = mysql_result($result, $i, 'ser_pdf1');
$titlelink = $ser_seo_title;
$titlelink = str_replace(" ", "-", $titlelink);
$categorylink = mysql_result($result, $i, 'ser_category');
$categorylink = str_replace(" ", "-", $categorylink);
$change_date = mysql_result($result, $i, 'ser_date');
$ser_short_desc = mysql_result($result, $i, 'ser_short_desc');
$ser_short_desc=stripslashes($ser_short_desc);
$newDate = date("F d, Y", strtotime($change_date));
echo "
";
$matchit="0";
$noimage=substr($ser_image1,0,1);
$novideo=substr($ser_video_link,0,1);
if ($ser_image1 != " ") {
echo "";
echo "";
echo "";
echo "$newDate";
echo " | ";
echo mysql_result($result, $i, 'ser_category');
echo "";
echo "";
echo "";
echo nl2br($ser_short_desc);
echo "
";
$matchit="1";
}
if ($matchit == "0" && $novideo != "" && $ser_image1 == " ") {
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "";
echo "$newDate";
echo " | ";
echo mysql_result($result, $i, 'ser_category');
echo "";
echo "";
echo "";
echo nl2br($ser_short_desc);
echo "
";
$matchit="1";
}
if ($novideo == "" && $noimage == " " && $matchit == "0" && $ser_image1 == " ") {
echo "
";
echo "";
echo "$newDate";
echo " | ";
echo mysql_result($result, $i, 'ser_category');
echo "";
echo "";
echo "";
echo nl2br($ser_short_desc);
echo "
";
$matchit="1";
}
}
mysql_close();
?>
if ($show_page > 1)
{
echo " ";
}
if($show_page != $total_pages || $show_page == 0 && $total_pages >= 2)
{
echo " ";
}
?>