Page 1 of 1

mysql-based directory needed for movie database

Posted: Sun Jun 19, 2005 9:53 pm
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.

Posted: Sun Jun 19, 2005 10:58 pm
by method_man
dont cross post

Posted: Sun Jun 19, 2005 11:18 pm
by server0000
I feel that this question is really about setting up a database.

Please advise where you think this post should be in.

Posted: Mon Jun 20, 2005 2:42 am
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)

Posted: Mon Jun 20, 2005 11:48 am
by server0000
Thanks, Tim, but I was looking to purchase a ready-made software with that feature... :?