Hello
I am building a new personal site that will have a few game reviews and things on it. i have built the database structure (well, planned it...). it has four tables:
games
platforms
gamesplatforms
reviews
of course, games come in more than one platform, so that is what gamesplatforms is for.
i want to display a list of games, basically as:
title: games.releasedate
releasedate: games.releasedate
consoles: [list of all platforms]
and then a link (using games.id)
i have produced a ms paint picture showing the database layout. what is the best way to retrieve this data? LEFT JOIN etc? I always get confused by things like this. and also, the list of consoles will be more than one often.
See : http://img272.imageshack.us/img272/2893/dblayoutqr3.png
i hope ive made it as clear as i can. i know its not the clearest thing ever...
cheers!!
I am building a new personal site that will have a few game reviews and things on it. i have built the database structure (well, planned it...). it has four tables:
games
platforms
gamesplatforms
reviews
of course, games come in more than one platform, so that is what gamesplatforms is for.
i want to display a list of games, basically as:
title: games.releasedate
releasedate: games.releasedate
consoles: [list of all platforms]
and then a link (using games.id)
i have produced a ms paint picture showing the database layout. what is the best way to retrieve this data? LEFT JOIN etc? I always get confused by things like this. and also, the list of consoles will be more than one often.
See : http://img272.imageshack.us/img272/2893/dblayoutqr3.png
i hope ive made it as clear as i can. i know its not the clearest thing ever...
cheers!!