Paging

[Anon]

Hi,

I am usinf php with MySql and i want a complete code for paging.

what i am doing is that a user selects a criteria and then the result is obtained based on that criteria selected.

Could you please help me ?

Regards,

shailen

[Anon]

http://www.phpbuilder.com/columns/rod20000221.php3

[techek]

Look for the MySQL-feature "limit". If you have a number of lines to show and only want to display a certain number from a certain offset you could use this :

SELECT * FROM <table> LIMIT 0, 20;
(selects all records from 0 to 19)

SELECT * FROM <table> LIMIT 1, 20;
(select all records from 20 to 39)

Just make two queries - one to find out how many records you have in total (COUNT()) and then another using LIMIT to select a small area of the total amount of records.

[shailen]

Thanks.

Well, it's working but i want that if i get 30 records, only "1 2 3" to be displayed at the bottom and not "1 2 3 4 5 Next".

Or even if i get 44 records, only "1 2 3 4" to be displayed at the bottom. Please help !

I am passing a parameter alphabet to the "search.php" and i have modified the code a bit as below:

<?php
{
$xalpha = strtolower(chr($alphabet));

$query = "select * from advertisers where advertiser like '$xalpha%' order by advertiser"; 
$result = mysql_query($query) or die("advertiser error");
$numrow = mysql_num_rows($result); 

print "$numrow record(s) found ...<br><br>";

$num=0; 
if(!isset($pgno)) 
{ 
$pgno=1; 

} 

$currentpage = $pgno; 
$pagesize = 10; 
$limit = 10; 

$pg = $numrow / $pagesize; 

for($a = 0; $a < $pg ; $a++) 
{ 

if($a == $pgno - 1) 
{ 
$num = $a * $pagesize; 
} 
} 

$query = "select * from advertisers where advertiser like '$xalpha%' order by advertiser limit $num, $limit "; 
$result = mysql_query($query) or die("advertiser error occured"); 
$numrow = mysql_num_rows($result); 


for($k = 0; $k < $pagesize; $k++) 
{ 
if($k > $numrow - 1) 
break; 
//print(mysql_result($result, $k, "advertisers.advertiser")."<br>\n");

$adver = mysql_result($result, $k, "advertisers.advertiser"); 
$adverid = mysql_result($result, $k, "advertisers.advertiserid");

print "<table border='0' cellpadding='2' cellspacing='1' width='100%'><tr><a href='display.php?advertiserid=$adverid'>$adver</a></tr></table>";
} 

if($pgno > 1 ) 
{ 
print("<br><a href=search.php?alphabet=$alphabet&pgno=" . $pgno = $pgno - 1 . ">[<< Previous]</a> "); 
} 

for($i = 1; $i <= 5; $i++) 
{ 


if($i == $currentpage) 
{ 
print(" ". $i . " "); 
} 
else 
{ 

print("<a href=search.php?alphabet=$alphabet&pgno=" . $i . ">". $i . "</a>\n"); 


} 

} 

if($currentpage < $pg) 
{ 
print("<a href=search.php?alphabet=$alphabet&pgno=" . $currentpage = $currentpage + 1 . ">[Next >>]</a>"); 
} 

}
?>