mysql-based directory needed for movie database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
server0000
Forum Newbie
Posts: 4
Joined: Sun Jun 19, 2005 9:35 pm

mysql-based directory needed for movie database

Post by server0000 »

Hello,

I am looking for a MySQL-based directory program that will allow me to categorize products under MULTIPLE headings.

For instance, the IMDB (movie database) site has movies categorized under multiple genres
(eg. Blade 3 can be under ACTION, SCI-FI, and HORROR), not just a single one.

Where can I find such a software?

Thanks.
method_man
Forum Contributor
Posts: 257
Joined: Sat Mar 19, 2005 1:38 am

Post by method_man »

dont cross post
server0000
Forum Newbie
Posts: 4
Joined: Sun Jun 19, 2005 9:35 pm

Post by server0000 »

I feel that this question is really about setting up a database.

Please advise where you think this post should be in.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

With the following tables you can realise what you want.. If you read a book on basic database design you'll know how to do it yourself next time..

categories(category_id, name, ...)
movies(movie_id, name, ...)
moviecategories(category_id, movie_id)
server0000
Forum Newbie
Posts: 4
Joined: Sun Jun 19, 2005 9:35 pm

Post by server0000 »

Thanks, Tim, but I was looking to purchase a ready-made software with that feature... :?
Post Reply