Sub-categories Tutorial

Hi, Chris.

I tried adding the line of code - 'categoryFormat' => 'onelevel', - but I get an error message on the page: http://www.tomlinsonelitehockey.com/pw_videosList2.php. This is what it looks like without that code: http://www.tomlinsonelitehockey.com/pw_videosList.php.

In this example, I only want Hockey Canada Skills Review to appear on the first page, followed by Balance and Agility on the next page, and finally all of the numbered items/links on a page that has the heading Balance and Agility.

Am I missing something, please?

So sorry - I forgot that I'd left the Bravenet password code on these pages. I've deleted them now, but I'll send a support request anyway.

By the way, this is the latest version of CMSB. It was upgraded earlier this week.

Hi Nigel,

Is your section a Category Menu? Did you follow the steps outlined in the first post?

Hi, Chris.

Jason is looking into this for me via a request ticket.

Cheers,

I have a multi-record section called "categories" has field (title)

I have another multi-record section called "articles" that has fields title ,details and category

In the CMS, you can choose which category a article goes to by drop-down with list options populated from the MySQL table "categories" above.

on My viewer pages i want to display articles title belong to the selected category as list on left side and display the details of the selected title in center area

the example is attached

how can i do that?

Hi,

What you need to do is when someone clicks on a category, you need to pass the category to the second page. You can then select all the categories that belong to this category.

For example, let's assume that the field in your articles section is called category and that you're using "num" as the value for this field. When they select a category on page one, it could look like this:

http://www.yoursite.com/page2.php?category=3

On page2.php you use getRecords() to select your articles. Since the name is the URL (category) matches the name of a field in articles, CMS Builder will automatically create your WHERE clause for you and only select articles that are in category 3.

Give this a try and let us know if you run into any trouble.

Thanks

PERFECT!!!!!!

thanks sooo much Jason

I add this code


'allowSearch' => '0',
'where' => 'category = ' . @$_REQUEST['category'],

Hi, Chris.

I've set up a demo for a client based on your tutorial, and it all seems to be working ok: http://www.commonsensedesign.net/demoTownship.php. There are a few things I'd like to do to amend this, though. (Please note that About Finance Department and Staff Directory are hand coded into the page and aren't controlled via CMSB).

1. At the moment the page lists all of the subcategory pages at the bottom of the page by default (Pre-authorized Payments, etc). Is there a way to avoid these appearing? I only want to show options for the category that the user has selected.

2. In my demo when you click on, say, Tax you're shown the subcategories Tax Rates, Tax and Water Certificates, etc. You have to click on Tax Rates to see the page within that subcategory; in this case the page is called Tax Rates Information. Is there a way to go straight from the Tax Rates link to the page in that subcategory? http://www.commonsensedesign.net/demoTownshipDetails.php?Tax-Rates-Information-2. In each of the subcategories there is only one page so there's no need to present an option of one. That creates an extra click for no reason. (See demo.jpg).

3. I have sub-navigation on the left hand side and I would like this to only show the top level categories; in this example, Pre-authorized Payments, Tax, and Water. I don't want the subcategories to show up here, which is what happens when you click on a top level category, either on the left or in the main content. This applies to the details page, too.

I've attached both the index and details pages.

Many thanks,