Limiting records per page?

[karimali831]

Hi people,

I'm trying to get this page LogicalCups || #ficomedia @ Qnet - COD4 Cups, Night Cups - News limited by X amount of records per page. Anyone know how I can do this please?

Much appreciated.

Thank you.

[Paul-sweet]

Hi there, when you do your query to the database to pull the info into your page.
Add LIMIT 1 to the query.

Example:

$sql = "SELECT * FROM table LIMIT 1;

Or change the 1 to however many results you would like to pull from the database.
:O)

[karimali831]

Yes but I want all records to be displayed into multi pages? Not just a limit itself.

[Paul-sweet]

Are you talking about pagination?

With links to the next page i.e:

<first page | 2 | 3 | 4 | 5 | last page>

[Dan]

Here is an article explaining how to do it.

Pagination - PHP Pagination - PHP MySQL Pagination

[karimali831]

Nice! but where it tells me to specify $max, this just breaks the page?

("SELECT * FROM ".PREFIX."cup_all_clans $max")

[Paul-sweet]

Hey karimali831
try this one out, its pretty basic, but if you have never worked with pagination before it will be a bit easier to understand.

PHP Freaks - Tutorial: PHP Basic Pagination

[karimali831]

Thanks
Working on it now.

[karimali831]

I tried many with no luck I'm afraid.
I thought I could just use include("pagination.php"); on main page and change the query but it will just break the page.

If you take a look at my clans.php maybe you can see the problem. Must I include the pagination script within clans.php itself? Again, breaks the page. Never used this before.

[jon123]

Not had a look at your script but try using mine.

$pagenum=$_GET['pagenum'];
$connect=connect to databse script..
//get count    
$query2 = "SELECT count(*)FROM TABLE";
$result2=mysql_query ($query2, $connection) or die('Queryproblem: ' . mysql_error() . '<br />Executed query: ' . $query2); 
$numrows=mysql_result ($result2,0,"count(*)"); 
$all=$numrows;
     
//the pagination

$rows_per_page = 8;
$last = ceil($numrows/$rows_per_page);
$pagenum = (int)$pagenum;
if ($pagenum < 1) {
$pagenum = 1;
} elseif ($pagenum > $last) {
$pagenum = $last;
}
$limit = 'LIMIT ' .($pagenum - 1) * $rows_per_page .',' .$rows_per_page;

if ($pagenum == 1) {
// echo "FIRST PREV";
} else {
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'>FIRST</a> ";
$prevpage = $pagenum-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$prevpage'>PREV</a> ";
}
echo " ( Page $pagenum of $last ) ";
if ($pagenum == $last) {
//echo " NEXT LAST ";
} else {
$nextpage = $pagenum+1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$nextpage'>NEXT</a> ";
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>LAST</a> ";
}
?>

[karimali831]

got it working! thanks

[shri34]

change the 1 to however many results you would like to pull from the database.