Pagination

[jerastraub]

I have a pagination script, i just need a tip on how to add "Displaying 1 to 9 (of 14 products)"

 

any help would be great!

[cyrixware]

I see... so every page your going to display 9 rows only?

 

<?
include("connDB.php");	

$Limit = 9; //Number of results per page

$SearchString=$_POST["lotId"]; // Get the search tearm

If($SearchString == "") $SearchString=$_GET["SearchString"]; // Get the search tearm

$page=$_GET["page"]; //Get the page number to show
If($page == "") $page=1; //If no page number is set, the default page is 1

//Get the number of results
$SearchResult=mysql_query("SELECT * FROM phase ORDER BY lotNum") or die(mysql_error());
$NumberOfResults=mysql_num_rows($SearchResult);

//Get the number of pages
$NumberOfPages=ceil($NumberOfResults/$Limit);
$SearchResult=mysql_query("SELECT * FROM phase ORDER BY lotNum LIMIT " . ($page-1)*$Limit . ",$Limit") or die(mysql_error());
While($row = mysql_fetch_object($SearchResult)) {
$x = $x + 1;
if ($x % 2 != 0)
{
	$x = $x + 1;
                  Echo $row->lotBlock . "<BR>";
                  Echo $row->lotNum . "<BR>";
}
}

$Nav="";
If($page > 1) {
$Nav .= "<A HREF=\"phase2.php?page=" . ($page-1) . "\"><<</A>";
}else{
//$Nav .= " << ";
}
For($i = 1 ; $i <= $NumberOfPages ; $i++) {
If($i == $page) {
$Nav .= "<B>$i</B>";
}Else{
$Nav .= "<A HREF=\"phase2.php?page=" . $i ."\"> $i </A>";
}
}
If($page < $NumberOfPages) {
$Nav .= "<A HREF=\"phase2.php?page=" . ($page+1) .  "\">>></A>";
}else{
//$Nav .= " >> ";
}
Echo "" . $Nav;
?>

[jerastraub]

Hello,

 

This is doing the pagination part ie.(<< 1 2) or (1 2 >>). I need it to also do "Displaying 1 to 9 (of 14 products)". 

[jerastraub]

much like the following:

 

Items 11-20 of 100 displayed. 

11 12 13 14 15 16 17 18 19 20 

first prev [1-10][11-20][21-30][31-40][41-50][51-60][61-70][71-80][81-90][91-100] next last 

back to home page 

[jerastraub]

"bump"

[jerastraub]

Anyone that can help me with this?

[sasa]

add

echo 'Displaying ',$page*$Limit-$Limit+1,' to ',($page*$Limit)<$NumberOfResults?($page*$Limit):$NumberOfResults, ' (of ',$NumberOfResults,' products)';

to cyrixware's code

[jerastraub]

This worked great, but i can't find the topic solved button