[!--quoteo(post=362692:date=Apr 7 2006, 07:22 PM:name=earl_dc10)--][div class=\'quotetop\']QUOTE(earl_dc10 @ Apr 7 2006, 07:22 PM) [snapback]362692[/snapback][/div][div class=\'quotemain\'][!--quotec--] Unless this isn't what you want, couldn't you just do [code] $query = mysql_query("SELECT Name, URL_Image_Small, Price, URL_Product, Product_Type, Category, Description, Popular FROM db WHERE Category LIKE '$category' ORDER BY Popular LIMIT 10"); [/code] [/quote] No, it's not really what I want... When I do that, it obviously limits my results to 10...but... What I want to do...(If I can explain it and make sense)...Is get all of the results from the initial query, [i]then[/i] limit to 10 per page... Otherwise, there are no pages... Just 10 results on one page... Make sense? Am I being too difficult? It sure is hard to explain something when you don't know a whole lot about it... [!--quoteo(post=362693:date=Apr 7 2006, 07:29 PM:name=badassrocker)--][div class=\'quotetop\']QUOTE(badassrocker @ Apr 7 2006, 07:29 PM) [snapback]362693[/snapback][/div][div class=\'quotemain\'][!--quotec--] No, it's not really what I want... When I do that, it obviously limits my results to 10...but... What I want to do...(If I can explain it and make sense)...Is get all of the results from the initial query, [i]then[/i] limit to 10 per page... Otherwise, there are no pages... Just 10 results on one page... Make sense? Am I being too difficult? It sure is hard to explain something when you don't know a whole lot about it... [/quote] Well... Here's the script I'm using to move between pages... Maybe this will make more sense... [code]<?php $categor = eregi_replace(' ','%20',$category); echo ("<br />"); if ($s >= 1){ $prev=($s - $limit); echo (" <a href=\"$PHP_SELF?category=$categor&s=$prev\"><< Prev 10</a> "); } $pages = intval($numrows/$limit); if ($numrows%$limit){ $pages++; } if (!((($s+$limit)/$limit) == $pages) && $pages!=1){ $next = $s+$limit; echo (" <a href=\"$PHP_SELF?category=$categor&s=$next\">Next 10 >></a>"); } $a = $s + $limit; if ($a > $numrows){ $a = $numrows; } $b = $s + 1; echo ("<p>Showing products $b to $a of $numrows</p>"); ?>[/code]