...

View Full Version : PHPmyadmin get multiple values by table ids



conware
07-11-2011, 01: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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum