converting a rs to allow my pagination to work

Hey Ray

Have set up a results page - in the first instance, content is filtered by 'productcategories' and want to add pagination using the below rs but I cannot get the select statements correct in the 2nd code block below (the first code block works fine without my pagination)

So I want to 'convert' this

<?php
$Categories = new WA_MySQLi_RS("Categories",$DBConnection,0);
$Categories->setQuery("SELECT productcategories.*, productcategories_2.CategoryName AS parentcategoryname, productcategories.CatPermalink, productcategories_2.CatPermalink AS parentpermalink, products.* FROM productcategories LEFT OUTER JOIN productcategories AS productcategories_2 ON productcategories_2.CategoryID = productcategories.CategoryParentID LEFT OUTER JOIN products ON products.ProductCategoryID = productcategories.CategoryID AND products.ProductLive = 1 WHERE productcategories.Live = 1 AND productcategories.CatPermalink = ? ORDER BY products.ProductDate ASC");
$Categories->bindParam("s", "".$_GET["perm"]  ."", "-1"); //permparam
$Categories->execute();
?>

to this

<?php
$maxRows_Categories =15;
$Categories = new WA_MySQLi_RS("Categories",$DBConnection,$maxRows_Categories);
$Categories->setQuery("SELECT ");
$Categories->bindParam("s", "".$_GET["perm"]  ."", "-1"); //permparam
$Categories->execute();

$CategoriesTotal = new WA_MySQLi_RS("CategoriesTotal",$DBConnection);
$CategoriesTotal->setQuery("SELECT count(1) a");
$CategoriesTotal->execute();
$Categories_Total = (int)$CategoriesTotal->Results[0]['a'];
$Req_Pages = ceil($Categories_Total/$maxRows_Categories);
?>

Am also trying to get the recordset to allow me to show alternate content if the category holds 0 products
Thanks

Jamie

I'm really confused about your updated code. You have an empty select statement, then a count statement in a separate recordset. I'm not sure what you are trying to do here, but the approach seems wrong. We may need to have a phone conversation and screen sharing so I can understand what you are trying to do and suggest the right way to go about it.

Hey Ray

I specifically left the second code block rs select statements blank as these are the ones I am trying to add the 'converted' select statement from the fist one into. Just copying the select from the 1st code block directly binto the 2nd cause an error

I purely set it up that way so that you could see the general structure of the RS that I needed to create with the 2nd code block

I am trying to replicate the pagination aspect from the attached page if that helps

I don't see where GalleryTotal is used on the page. I also am not familiar with count(1) in a SQL statement, so I'm not sure why it is necessary. Can't you use the ->TotalRows attribute of the original query?

The rs you helped me with a few months back and set it up that way....so am unable to answer why you wpould use count(1) or GalleryTotal - its just what you decided to do

I'm going to have to do screen sharing to figure out why I did that. It doesn't seem like it would be necessary, but I'm sure if I dig around I can figure out what I was doing and come up with a good solution.