page number stuff

[JimD]

So I use this code

$limit_2 = "10";

$limit = $limit2; 
$query_count = "SELECT * FROM ... ORDER BY TimeStamp"; 
$result_count = mysql_query($query_count); 
$totalrows = mysql_num_rows($result_count); 
$PHP_SELF = $_SERVER['PHP_SELF']; 

if(empty($page)) 
{ 
$page = 1; 
} 

$limitvalue = $page * $limit - ($limit); 
$query = "SELECT * FROM ... ORDER BY TimeStamp LIMIT $limitvalue, $limit"; 
$result = mysql_query($query) or die("Error: " . mysql_error()); 

if(mysql_num_rows($result) == 0) 
{ 
echo("<center><b>Empty</b></center>"); 
} 
while($row = mysql_fetch_array($result)) 
{ 

echo $row['stuff'];

if($page != 1) 
{ 
$pageprev = $page - 1; 
//echo("<a href=\"$PHP_SELF?page=$pageprev\"><font size=1>Previous</font></a>&nbsp;");  

echo("<font size=1>Pages:&nbsp;</font>"); 
} 
else 
{ 
//echo("Pages:&nbsp;"); 
echo("<font size=1>Pages:&nbsp;</font>"); 
} 

$numofpages = $totalrows / $limit; 


for($i = 1; $i <= $numofpages; $i++) 
{ 
if($i == $page) 
{ 
echo("<font size=1>".$i."</font>&nbsp;");
} 
else 
{ 
echo("<font size=1><a href='index.php?page=$i'>$i</font></a>&nbsp;"); 
} 
} 

if(($totalrows % $limit) != 0) 
{ 
if($i == $page) 
{ 
echo("<font size=1>" . $i . "</font>&nbsp;"); 
} 
else 
{ 
echo("<a href='index.php?page=$i'><font size=1>$i</font></a>&nbsp;"); 
} 
}

using that code or something similar how can I make a link that links to the very last page. Let's say I have 10 pages. I want a link that when you click on it (<a href=index.php?page=$last> or something like that), it forwards you to page index.php?page=10?

Little help please.

[thessoro]

index.php?page=$numofpages... ???? is just a variable you have used in your code...

[JimD]

Omg. I'm such a retard. My brains stop working after 12 hours of programming.

[JimD]

Hmm. There's a follow up to this question. When I do index.php?page=$numofpages and let's says I have 36 rows, it forwards me to page 1.8. How do I round it off to the next whole number?

[thessoro]

you have to do:

$numofpages=ceil ($totalrows/$limit);

if you just round, for example round (3.1) will give 3 and this is not a good idea when paging cause you would lose information.

Use ceil () instead. ceil (3.1)=4

[JimD]

Ok. Thank you 😃