12LEE

Hi All

I want to build a corporate site using some Dreamweaver templates. I really want to use a CMS and have the site data driven for ease of maintenance.

I've looked at a few free/cheap CMS (Ariadne, Supercharged CMS, Webedit Pro) but so far, can't find something that's right....

The main issue I've got is nesting of subcategories. I want a structure along the lines of:

Corporate/Products/Resellers/News

and the main thing is that Products needs to be multilevel, e.g.

Products
Category 1
Product Type 1
Product A
Product B
Product C
Product Type 2
Product A
Category 2
Product Type 1
Product A
Product B
Product Type 2
etc

It's basically a store/catalogue structure but (a) the site won't be an ecommerce site and (b) I'm looking for more CMS features than I've seen in lightweight store packages.

Any suggestions?

Cheers

Lee.

SJ_Skyline

Lee,

Is this what you have in mind?

12LEE

yeah

SJ_Skyline

TBH, If you can't find a cms that meets your needs then I would consider coding from scratch.

You can accomodate your products in a simple Access DB across 3 tables:

tblProduct:
intProductID (PK)
intProductTypeID (FK)
strProductName
strProductDescription
curProductPrice
...

tblProductType:
intProductTypeID (PK)
intCategoryID (FK)
strProductTypeName
...

tblCategory:
intCategoryID (PK)
strCategoryName
...

Link these together via their Primary and Foreign keys and you have your structure. On a code level you can quite easily submit SQL queries to the database via ASP. e.g. "SELECT * FROM tblProduct, tblProductType WHERE tblProduct.intProductTypeID = tblProductType.intProductTypeID AND strProductTypeName = 'Exhaust'"

12LEE

Thanks.

The site's on a Linux box with MySQL. Best read up on Dreamweaver MX/php/MySQL.

GaryK

Lee,

If its running on linux then take a look at geeklog, www.geeklog.net thats a really cool CMS with the ability for users to personalise content based on their preference, themes, plug-ins etc., Just need mySQL and you're away, geeklog itself uses geeklog so you can get an idea of what it can do.

cheers

Gary

stevencotton

Double-o-post removal


[Edited by stevencotton - 5/29/2003 12:08:10 PM]

stevencotton

Bricolage is a nice well known open source CMS you could use too.

Edited to add, if it's ease of use you're after then I'd totally avoid PHP. I'd avoid PHP anyway, but especially for ease of maintenance