Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
server0000
Forum Newbie
Posts: 4 Joined: Sun Jun 19, 2005 9:35 pm
Post
by server0000 » Sun Jun 19, 2005 9:53 pm
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 » Sun Jun 19, 2005 10:58 pm
dont cross post
server0000
Forum Newbie
Posts: 4 Joined: Sun Jun 19, 2005 9:35 pm
Post
by server0000 » Sun Jun 19, 2005 11:18 pm
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 » Mon Jun 20, 2005 2:42 am
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 » Mon Jun 20, 2005 11:48 am
Thanks, Tim, but I was looking to purchase a ready-made software with that feature...