[SOLVED] pagination getting id as well as page

[contra10]

hi i can link to another page within the pagination but i need to get the id of group in order to continue to echo the results heres my code

 

<?php
if(is_numeric($_GET['id'])){

$id = $_GET['id'];

  $insert3= "SELECT * FROM post_grp WHERE grpid = '$id' ORDER BY pgid DESC";
$topic3 = mysql_query($insert3) or die(mysql_error());


}
//This checks to see if there is a page number. If not, it will set it to page 1 
if (!isset($pagenum)) 
{ 
$pagenum = (isset($_GET['pagenum'])) ? $_GET['pagenum'] : 1; 
} 

//Here we count the number of results 
//Edit $data to be your query 
$data = mysql_query("SELECT * FROM post_grp WHERE grpid = '$id' ORDER BY pgid DESC") or die(mysql_error()); 
$rows = mysql_num_rows($data); 

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

//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 = "SELECT * FROM post_grp WHERE grpname = '$grpname' ORDER BY pgid DESC $max";
$posts = mysql_query($data_p) or die(mysql_error()); 

//This is where you display your query results
while($info = mysql_fetch_array($posts)) 
{ 
$userpost= "{$info['grppost']}";
$username= "{$info['username']}";
$usermonth= "{$info['month']}";
	$userday= "{$info['day']}";
	$useryear= "{$info['year']}";

echo "<table border='1' align='center'>";
echo "<tr>";
	echo"<td width= '500' align='center'> $userpost</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='right'>Posted by $username on $usermonth, $userday $useryear</td>";
echo "<tr>"; 
echo"</table>";
} 
echo "<p>";

// This shows the user what page they are on, and the total number of pages
echo " --Page $pagenum of $last-- <p>";

// 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 
{
echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=1'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=$previous'> <-Previous</a> ";
} 

//just a spacer
echo " ---- ";

//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='http://localhost/groupsio/post.php?id=$id?pagenum=$next'>Next -></a> ";
echo " ";
echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=$last'>Last ->></a> ";
} 

?>

 

i need the results to continue on a different page with the id still attached in the url

[timmah1]

These 2 lines are wrong

echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=1'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=$previous'> <-Previous</a> ";

 

They should be

echo " <a href='http://localhost/groupsio/post.php?id=$id&pagenum=1'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='http://localhost/groupsio/post.php?id=$id&pagenum=$previous'> <-Previous</a> ";

 

And these

echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=$next'>Next -></a> ";
echo " ";
echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=$last'>Last ->></a> ";

 

should be

echo " <a href='http://localhost/groupsio/post.php?id=$id&pagenum=$next'>Next -></a> ";
echo " ";
echo " <a href='http://localhost/groupsio/post.php?id=$id&pagenum=$last'>Last ->></a> ";

[contra10]

its funny how in programming there is no room for a simple mistake...

 

Thank you for pointing out the obvious