man12_patil3 Posted December 10, 2008 Share Posted December 10, 2008 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 ?? Link to comment https://forums.phpfreaks.com/topic/136320-pagination-by-10-10-records-per-page/ Share on other sites More sharing options...
priti Posted December 10, 2008 Share Posted December 10, 2008 you can google for pagination class in PHP and you will get a lot of code help. Link to comment https://forums.phpfreaks.com/topic/136320-pagination-by-10-10-records-per-page/#findComment-711350 Share on other sites More sharing options...
msinternet Posted December 10, 2008 Share Posted December 10, 2008 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 Link to comment https://forums.phpfreaks.com/topic/136320-pagination-by-10-10-records-per-page/#findComment-711400 Share on other sites More sharing options...
bluesoul Posted December 10, 2008 Share Posted December 10, 2008 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. Link to comment https://forums.phpfreaks.com/topic/136320-pagination-by-10-10-records-per-page/#findComment-711403 Share on other sites More sharing options...
Maq Posted December 10, 2008 Share Posted December 10, 2008 Please read this tutorial. Post if you have a specific question. Link to comment https://forums.phpfreaks.com/topic/136320-pagination-by-10-10-records-per-page/#findComment-711430 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.