Re: Problemo with QUERY and LIMIT

[Travis Thomas]

I've tried that and it does display results... However it only displays 10 results...(I know that obviously makes sense...) I need to display all results, but limit them to 10 per page AFTER the initial query. Does that make sense?

Am I making this way too difficult?

This might also help...

This is the script I have to move between pages:

<?php

$categor = eregi_replace(' ','%20',$category);

echo ("<br />");

if ($s >= 1){
$prev=($s - $limit);
echo ("&nbsp;<a href=\"$PHP_SELF?category=$categor&s=$prev\">&lt;&lt; Prev 10</a>&nbsp;&nbsp;");
}
$pages = intval($numrows/$limit);

if ($numrows%$limit){
$pages++;
}
if (!((($s+$limit)/$limit) == $pages) && $pages!=1){
$next = $s+$limit;
echo ("&nbsp;<a href=\"$PHP_SELF?category=$categor&s=$next\">Next 10 &gt;&gt;</a>");
}
$a = $s + $limit ;
if ($a > $numrows){
$a = $numrows ;
}
$b = $s + 1 ;
echo ("<p>Showing products $b to $a of $numrows</p>");
?>

(I think) That's partly why I need to use " $query .=" LIMIT $s,$limit"; " in order for everything to work...