conware
07-11-2011, 12:33 AM
Hi don't really know how to call this but I have two tables in phpmyadmin
The look like this:
Game Table:
------------------------
ID TITLE GENRE_ID
------------------------
1 SMB 1
Genre Table
------------------------
ID GENRE
------------------------
1 platform
When I do my queries I can select the genre by genre_id in the game table.
But is it possible to get a second ore a third genre if a video game has more then one? And how should I change my tables to make it work.
If its not possible I'll just put the genre in the same table as the Games.
Thanks for any replies.
The look like this:
Game Table:
------------------------
ID TITLE GENRE_ID
------------------------
1 SMB 1
Genre Table
------------------------
ID GENRE
------------------------
1 platform
When I do my queries I can select the genre by genre_id in the game table.
But is it possible to get a second ore a third genre if a video game has more then one? And how should I change my tables to make it work.
If its not possible I'll just put the genre in the same table as the Games.
Thanks for any replies.