Pagination by 10-10 records per page........

[man12_patil3]

php is new lang. for me. i have 2000 record which is dispaly on web page(10 record each page) by pagination. but problem is that i get 200 links of pages on webpage which take large space. I want to display it in a grop of 10-10 pages. where is the code for it.

 

can anybudy help me ??

[priti]

you can google for pagination class in PHP and you will get a lot of code help.

[msinternet]

I assume you arte using a SQL database. If so you need teh LIMIT command

 

if(isset($_GET['pageid']) {
$start = ($_GET['pageid'] -1)*10;
} else {
$start = 0;
}

$query = "SELECT * FROM `links` LIMIT '" . $start . "',10"

 

etc.

 

any of teh bits in this you don't get try w3schools.com they have a good php section.

 

Martin

[bluesoul]

As a note, there's not a terribly easy way to do it in MSSQL as there's not a LIMIT function in the usual sense.  You have to use two TOP statements.  Google had a good article on how to do it.

[Maq]

Please read this tutorial.  Post if you have a specific question.