Multiple Manufacturer "type" systems.

[con4mity]

New contribution "Data Collectors 1.0"

 

I've been working on this mod for a few days. Basically by creating more mfg type systems inside the product table I can collect more relationtional data. For example, on books I'd like publisher, author, writer, artist, and I can accomplish this I know by adding publisher_id to the products table and then copy all the manufacturer related code to a new publisher system.

 

(I need to create additional manufacturers systems. By this I mean, tables, files, display, search the whole nine yards.)

 

I want to add, for example, author_id to the products table, and be able to link authors to the products. I want then to be able to add a drop down in the manufacturer box that will populate just like manufacturer box does. And then I can select an auther and get a list of books by that author. I'm using the manufacturer for publisher information, and this new one for authors, but I'd like to be able to add others collectors as well.

 

The problem I ran into is that once all this done and I have a new dropdown on my homepage for titles, just under manufacturere, selecting it doesn't give me the list. You can see this here: http://www.ecorey.com

 

I notice two problems, not sure which is most important. The URL isn't working with SEO, and the results isn't as expected.

 

I think I Must build some case somewhere about title_id>=0 but not sure where, any help?

 

Corey