close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Display Sub-Categories according to chosen Main Category

Thread began 10/10/2013 2:30 pm by joerg431091 | Last modified 10/16/2013 9:49 am by joerg431091 | 1715 views | 10 replies |

joerg431091

Display Sub-Categories according to chosen Main Category

Hi,

I am trying to display certain subcategories in the sub-navigation of my products_results.php page according to what main categories was chosen in the main navigation:

So I like to have a Top navigation for all pages that have categories and drop down menus such as for example:

Main: Espresso & Coffee
Drops down to: - Espresso Machines
- Accessories
- Parts


If a user clicks on "Accessories" for example - the side navigation that will be on the products_results.php page should show only the sub categories that are available for Accessories and if the user clicks on "Parts" for example, only the sub categories available for parts should be shown on the product_results.php page.

I have a vague idea that this might be solved with relation database fields and tried to play around with it with no success.

Is there any tutorial or post that explains the step by step process of how to achieve this?

Thanks so much and best regards,

Joerg

Sign in to reply to this post

Jason ByrnesWebAssist

you will need a categories and subcategories table:

categories:
categoryID - Primary Key
categoryName

subcategories:
subcategoryID - primary Key
subcategoryCategoryID - relates to the categories.categoryID column
subcategoryName

the links from the category listing should pass the categoryID as a url variable

the recordset that shows the subcategories should use the URL Variable to filter the subcategory table using the subcategoryCategoryID column

Sign in to reply to this post

joerg431091

Hi Jason,

Thanks a lot. That makes sense and i think I am close to understand it and get it to work.

Could you give me an example for the link passing the categoryID as a url variable? I think I am making a mistake with this one.

Thanks again,

Joerg

Sign in to reply to this post

Jason ByrnesWebAssist

This is an example using a URL Variable named CatID to pass category ID 12:
page.php?CatID=12

Sign in to reply to this post

joerg431091

Awesome. That worked. Thank you so much!!!!!

Sign in to reply to this post

Jason ByrnesWebAssist

glad to hear it is working.

Sign in to reply to this post

joerg431091

Absolutely my friend. Your two replies pretty much demystified the entire Database Relationships for me and makes it much easier for me going forward. You guys are worth every single dollar we pay for your products. Thanks again.

Sign in to reply to this post

Jason ByrnesWebAssist

you're welcome.

Sign in to reply to this post

joerg431091

Hi Jason,

I have a follow up question and was hoping you could point me in the right direction:

Everything works great now that once clicked on the main navigation, the product_results.php page shows the sub categories of that particular main category that are stored in the DB.

Those sub-categories are displayed in the products_results.php page in a single recordset row using a repeat section as such:

<div class="general-block-list">
<ul class="categories">
<?php do { ?>
<li><a href="#"><?php echo $row_Recordset2['SubCatName']; ?></a></li>
<?php } while ($row_Recordset2 = mysql_fetch_assoc($Recordset2)); ?>
</ul>
</div>

So there might be 5 sub-categories shown for example. What I can't figure out is how to address the links to those individual sub-categories since I only have that one row of code.

II found a tutorial about dynamic menu navigation on webassist. Would this be a solution or is there any other way I can do this.

Thanks again for your help,

Joerg

Sign in to reply to this post

Jason ByrnesWebAssist

your link code:
<a href="#"><?php echo $row_Recordset2['SubCatName']; ?></a>

you can add the link to the subcat page and pass the subcat ID in the href:
<a href="subcat.php?SubCatID=<?php echo $row_Recordset2['SubCatID']; ?>><?php echo $row_Recordset2['SubCatName']; ?></a>

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...