Multiple category problem

[tguill]

I'm using PHP/MySQL

My goal is to make an e-commerce website that sells videos.

The problem I'm running into is how to handle multiple categories.

I'm selling travel videos. So I'll have a video that is about taking a cruise through Europe. That cruise might go through multiple countries. Stop at multiple cities. And might visit mulitple points of interest. On the cruise they might visit vineyards and discuss castles.

On the website side I want a user to find this video when they browse for:

Browse by Geographic Location-

Europe :
Europe : Country A
Europe : Country B
Europe : Country A : Location 1
Europe : Country A : Location 2
Europe : Country A : Location 3
Europe : Country B : Location 1
Europe : Country B : Location 2
Europe : Country B : Location 3

Browse by Special Interest -

Special Interest : Wine :
Special Interest : Castles:

---

This is just one example of how I can have one product that belongs in many places on my site.

The problem I'm running into is how to treat them in the database so I can pull them out and display them on my website.

Are there shopping carts out there that can do this now?

Any suggestions would be most helpful.

Thanks,

[_____]

Hi friend,

so, u mean u don't plan to program it urself

i am new, but if you plan to do it urself, the database will not that complicated as i think

something like this can work

1 table = videos
4 columns =
videoId | country | location | interest

country = a,b
location = 1,2,3
interest= wine,castle

---

if u want to search for a ready one
i think there is a lot
i heard a lot about
os ecommerce, but i didn't try it
u can search on free scripts site like
hotscripts.com