PDA

View Full Version : PHPmyadmin get multiple values by table ids



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.