[cellgeek]

Not sure if other people are having the same thing happening... but 4 categories per item just arenБ─≥t enough.... IБ─≥m forced to clone and item and add more categories with the same item... but then you get duplicate items in the search.... I have some items that go into 7 or more different categories... let me know what you guys thing...
I was writing a shopping cart script my self... and thatБ─≥s one of the things that really got my attention. The way I was doing it was having a different table in MySQL that would refer to the category and products table...
Instead of an item pointing to a category, a list of categories can be added to one product...
Example:
Category table
ID 1 - Name Something
ID 2 - Name Else

Item Table
ID 34 - First Item
ID 56 - Second Item

Link Table
CategoryID 1 - ItemID 34
CategoryID 1 - ItemID 56

And so on...
That way... You can have one item in as many categories as you want.

Let me know what you guys think.... would really like to see something like this added to the script... I know itБ─≥s a BIG change but IБ─≥m sure its well worth it.

Pogos Abdunuryan
______________________