My Collection

This is just a test in php to read a MySQL table with part of my collection in it.

My Systems

1, Dreamcast
3, Gameboy (Original)
4, Gameboy Color
2, Saturn
5, XBox

The Regions

1, EUR
3, JPN
2, USA

Types

3, Accessory
2, Game
1, System

A test record

1, 1, 2, Ikaruga, 3, with postcards

which translates to:
Dreamcast, Game, Ikaruga, JPN, with postcards

via the lovely command:
"select system, type, game_name, region, game_comment from games left join gamesystems on (games.game_system=gamesystems.sys_id) left join gameregions on (games.game_region=gameregions.reg_id) left join gametypes on (games.game_type=gametypes.typ_id)"

I wonder if the database structure is right :)
Full dump of my database

Valid XHTML 1.1!
(c)Gary Barker, 2003
Cookies set: Array ( )