[SOLVED] how would you construct

[MikeDXUNL]

not actually HOW you do it, but how you would

 

on Xbox there are achievements for games.

 

if I have a database with a table called 'games' and lets say I have The HULK videogame.

that is 'gameid'=1 in an entry

 

 

now there is gonna be an 'achievements table'

the achievements table will contain `achievement name`, `achievement description`, `achievement picture` and so on

 

 

how should i construct the table to have all the acheivements and stuff?

should i make 1 achievement per row? or how?

 

if you need me to reword this, just ask.

 

Thanks in Advance,

Mike

 

[digitalgod]

so something like this?

 

games

+-------+-------------+

|  id      |  title            |

+-------+-------------+

| 1      |    The HULK  |

+-------+-------------+

 

 

achievements

+-------+-------------+---------------------+--------------------------+-----------+

|  id      |  gameid        |        name              |          description            |    picture  |

+-------+-------------+---------------------+--------------------------+-----------+

| 1        |      1          |  Achievement #1    | bla bla bla                      | img1.jpg    |

+-------+-------------+---------------------+--------------------------+-----------+

 

obviously you do 1 achievement per row and you assign it a gameid that way you can join the tables together

 

hope that helps

 

[MikeDXUNL]

that is what I ended up doing. thanks for the help