Show all records via link

My client would like to include an option in the recordset navigation to show all the items in the recordset on the ProductsResults page. Is that possible?

Products_Results.php?S_ProductName=%20&Search=1

should do the trick
Search=1 to trigger the search and S_ProductName=%20 to clear the previous search.

Sorry, Jason - I don't think I was clear. Rather than showing 5 items in the recordset (or in my case 12) per page, I'd like to show all the items in a single page. Anyway to pull that off?

Ahhh, OK. the number of records that is displayed on the page is controlled by the repeat region. In the server behaviors list, double click the repeat region server behavior and change it to show all.

The repeat section is grayed out in dreamweaver? If I cant double click it which line of code do I change to accomplish what you just explained to previous thread and what is the code?
Thank you

change:

$WADAProducts = mysql_query($query_limit_WADAProducts, $localhost) or die(mysql_error());

to:

$WADAProducts = mysql_query($query_WADAProducts, $localhost) or die(mysql_error());

Originally Said By: Jason Byrnes

  Ahhh, OK. the number of records that is displayed on the page is controlled by the repeat region. In the server behaviors list, double click the repeat region server behavior and change it to show all.  

So you're saying that I should create a link to a version of the ProductsResults page with the repeat region set to show all? Is there any way to do that by passing a parameter to the same page?

Create the show all link to pass a QS Parameter:

<a href="results.php?showall=1">Show All</a>

Then change the following line:

$WADAProducts = mysql_query($query_limit_WADAProducts, $localhost) or die(mysql_error());

to:

if(isset($_GET['showall']) && $_GET['showall']== 1) {

  $WADAProducts = mysql_query($query_WADAProducts, $localhost) or die(mysql_error());

} else {

  $WADAProducts = mysql_query($query_limit_WADAProducts, $localhost) or die(mysql_error());

}

Beauty. Thanks.

No worries Joe.