Category not working as intended

The trick is to break it down page by page and figure out what you want each page to do. Then knock off the items (or requirements) one by one.

My guess is you want that next page to show all the records that are children of the selected record number (which is in the url). Your code probably will look like this:

$parentNum = getNumberFromEndOfUrl();
...
"where" => " parentNum = '$parentNum' ",

You need to put the parentNum = part a little higher above the getRecords() call though.

Hope that helps!

wow Dave, i appreciate your patience on this. So after further inspection, here's what should be happening.

On the main categories page:
http://209.62.14.161/products/furnlistList.php
Should list the categories, as mentioned before.

Now, when clicking on a category, it should, in theory, go go another "furnlistList.php" page to list the subset of categories in each. However, it is at present going directly to the "furnlistDetail.php" page, whether there is a product in there or not. (Very confusing!!!)

So, when there is an actual product in the Main Category page, clicking on it will bring up the Details page as expected (not wanted from this main list, but what have you.

Normally, if you clicked on a category with no products in it, you would go to the obligatory "No Record Found" entry, but this isn't happening... The furnlistDetail.php page is being listed as if there is a product there, when nothing even exists!!

For the record, I took the Square Table Product out and re-inserted it to no avail....

This is just that seems to just miss the intention...

Yes, it's killing me.

there are no "sub-categories" being created, regardless of what i try in the Admin.... I've been a huge fan right up until this moment...