If this is your first visit, check our documentation. To post, register or login.
Forums / Setting Up Categories, Products, Attributes / Link to multiple categories with mysql?

Link to multiple categories with mysql?

Locked

Started by hrm on 8 Sep 2006, 4:22 PM · Views: 3,118

Results 1 to 3 of 3
This thread is locked. New replies are disabled.
8 Sep 2006, 4:22 PM
#1
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Link to multiple categories with mysql?

Is it possible to link products to multiple categories using mysql? If I insert a new row into the products_to_categories table will it break anything?

Thanks.

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison

8 Sep 2006, 4:25 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: Link to multiple categories with mysql?

You can do that, as long as you don't REMOVE anything from the table, nor edit existing records.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

8 Sep 2006, 4:29 PM
#3
hrm avatar

hrm

New Zenner

Join Date:
Oct 2005
Posts:
95
Plugin Contributions:
0

Re: Link to multiple categories with mysql?

Thanks! It will save a ton of time for me.

Heather
Results! Why, man, I have gotten a lot of results.
I know several thousand things that won't work.
----Thomas Edison