Break Returned Results

zzz

Is there a simple solution of displaying a limited number of results returned from a table. Say I have a 1000 entries and I'd like to have them displayed 50 per page and have a link to the next batch and so on...

diego25

Check out LIMIT, e.g.

SELECT * FROM table LIMIT 50

Diego

zzz

Ok, we're getting closer here. Let's say I do this on the first page, and place a link to page 2. How do I get the next 50 results?..

ovisopa

Hy zzz,
I use something like this on my page, try it and if you have any problems .... post again 🙂

<?
require("db.inc.php");

$sql2 = "select * from mouse";

$sql_result2 = mysql_query($sql2);
$num =  mysql_num_rows($sql_result2);

$per_page = 5;    

if ($offset == ""){$offset = 0;}

// Count pages
$pages = $num/$per_page;
$pages = ceil($pages);

// list/loop db records here

$query="SELECT * FROM mouse LIMIT $offset,$per_page";
$result=mysql_query($query);
while($i=mysql_fetch_array($result))
{
..........................
}
// nav here
$forward = $offset + $per_page;
$rewind = $offset - $per_page;

if ($offset == 0){

$p_f = 1;
$p_r = 1;

}
$p_f = $p_f + 1;
$p_r = $p_f - 2;


if ($offset > 0){
    echo " <a href=\"index.php?offset=$rewind&p_f=$p_r\"><< Back</a> ";
    }

if ($forward < $num){
    echo " <a href=\"index.php?offset=$forward&p_f=$p_f\">Forward >></a><BR>";
    }

bye

zzz

Thanks.

I'm not that experienced in PHP but it appears that some of the functions in your dode come from that included file.

ovisopa

Originally posted by zzz
Thanks.

I'm not that experienced in PHP but it appears that some of the functions in your dode come from that included file.

I didn't understand what you sad here, can you be more explicit??

see ya