Pagination question?

[lct]

Trying to do pagination with 2 variables.

 

http://www.chicago3media.com/new_site/cat_page_test.php

 

If you go there, click on one of the links to the left, then click on Newer Post (to the right of the images), it just goes blank. Now I know that is because the $catID is not being carried over when you try to go to the next page of videos. Stuck on this one, so any help would be appreciated.

 

<?php
require('connect.php');

function Category($catID){
$catNav = mysql_query("SELECT * FROM jos_hwdvidscategories WHERE id = '$catID'");
$catNav_arr = mysql_fetch_array($catNav);
$catRealID = $catNav_arr['id'];
$catName = $catNav_arr['category_name'];

echo '<div id="nav-wrap">';
echo '<a href="cat_page_test.php?' . $catID . '">';
echo $catName;
echo '</a>';
echo '</div>';

}

echo '<div id="main-wrap">';
echo '<div id="navbar-wrap">';
Category($catID = '16');
Category($catID = '3');
Category($catID = '14');
Category($catID = '15');
Category($catID = '5');
Category($catID = '6');
Category($catID = '7');
Category($catID = '9');
Category($catID = '10');
Category($catID = '11');
Category($catID = '12');
Category($catID = '19');

echo '</div>';

echo '<div id="fvm-wrap">';

if(isset($_GET['16'])){
	Display_Category($catID = '16');
}
else if(isset($_GET['3'])){
	Display_Category($catID = '3');
}
else if(isset($_GET['14'])){
	Display_Category($catID = '14');
}
else if(isset($_GET['15'])){
	Display_Category($catID = '15');
}
else if(isset($_GET['5'])){
	Display_Category($catID = '5');
}
else if(isset($_GET['6'])){
	Display_Category($catID = '6');
}
else if(isset($_GET['7'])){
	Display_Category($catID = '7');
}
else if(isset($_GET['9'])){
	Display_Category($catID = '9');
}
else if(isset($_GET['10'])){
	Display_Category($catID = '10');
}
else if(isset($_GET['11'])){
	Display_Category($catID = '11');
}
else if(isset($_GET['12'])){
	Display_Category($catID = '12');
}
else if(isset($_GET['19'])){
	Display_Category($catID = '19');
}

//============================================
function Display_Category($catID){
if (!(isset($pagenum))) 
{ 
$pagenum = 1; 
} 

//Here we count the number of results 
//Edit $data to be your query 
$data = mysql_query("SELECT * FROM jos_hwdvidsvideos WHERE category_id = '$catID' AND published = 1 ORDER BY id DESC") or die(mysql_error()); 
$rows = mysql_num_rows($data); 

//This is the number of results displayed per page 
$page_rows = 6; 

//This tells us the page number of our last page 
$last = ceil($rows/$page_rows); 

//this makes sure the page number isn't below one, or more than our maximum pages 
if ($pagenum < 1) 
{ 
$pagenum = 1; 
} 
elseif ($pagenum > $last) 
{ 
$pagenum = $last; 
} 

//This sets the range to display in our query 
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;

  //This is your query again, the same one... the only difference is we add $max into it
$data_p = mysql_query("SELECT * FROM jos_hwdvidsvideos WHERE category_id = '$catID' AND published = 1 ORDER BY id DESC $max") or die(mysql_error()); 
//This is where you display your query results
	while($fetch_arr = mysql_fetch_array($data_p)){
		$fVideoID = $fetch_arr['video_id'];
		$fTitle = $fetch_arr['title'];
		$fViews = $fetch_arr['number_of_views'];
		$fID = $fetch_arr['id'];



		echo '<div id="fv-wrap">';

		echo '<div id="fv-thumb">';

			echo '<a href="http://www.chicago3media.com/video-categories.html?task=viewvideo&video_id=' . $fID . '">';

			echo '<img src="http://www.chicago3media.com/hwdvideos/thumbs/';
			echo $fVideoID;
			echo '.jpg" . width="128px" height="76px"  />';


			echo '</a>';

		echo '</div>';

		echo '<div id="fv-title">';


			if(strlen($fTitle) <= 24){
			echo '<a href="http://www.chicago3media.com/video-categories.html?task=viewvideo&video_id=' . $fID . '" . class="main-link">';
			echo $fTitle; 
			echo '</a>';
			}

			else{
				echo '<a href="http://www.chicago3media.com/video-categories.html?task=viewvideo&video_id=' . $fID . '" . class="main-link">';
				echo substr($fTitle, 0,25) . '...';
				echo '</a>';
			}

			echo '<div id="fv-views">';
			echo $fViews . ' views';
			echo '</div>';

		echo '</div>';

	echo '</div>'; 
	}

// First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.
if ($pagenum == 1) 
{
} 
else 
{
$previous = $pagenum-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'>Older Post</a> ";
} 

//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
if ($pagenum == $last) 
{
} 
else {
$next = $pagenum+1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Newer Post</a> ";
} 

  // This shows the user what page they are on, and the total number of pages
echo '<br />';
echo 'Page ' . $pagenum . ' of ' . $last;
}
?>