Business directory idea

2 posts by 2 authors in: Forums > CMS Builder
Last Post: November 2, 2016   (RSS)

By Jesus - November 1, 2016

Hi,

I'm thinking to create a Business Directory with CMSBuilder but need some advice in order to define properly the tables I need.

I'm starting with 2 tables (Categories / Listings). Listings will have a field to match the proper category where it fits and basically I got this thing going. What I'm thinking here its how can I create the SEF urls for each listing.

Example.- I'm looking for something like this:

Root/Category name/Subcategory name/Listing name

So, any ideas on how can I get going the categories table in order to get the proper path on each listing or while browsing the directory?

My categroy table goes like this:

ID
Category name
Parent (Select field)

My listings table goes like this:

ID
Listing
Category (related to the category table)
URL
Phone number
Listing description

Thanks in advance for pointing me to the right direction, CMSBuilder might be agood fit for this.

Jesus