I have a game related website that I have been building for a while now. It has a profile area where the members enter a profile and that data can be displayed to other users, sorta like the profiles here.
My problem is this: I would like to grant awards to members and each award has it's own image to be displayed within the profile. I am confused as to how to do this when each member may recieve multiple awards.
My Table is set up to so that the profile information is one table and it has a field for awards. I was thinking that I could assign that field a '0' so that the display will know to print out "No Awards Yet".
BUT- if it is set to 1, then the display would then go to the MySQL Database and look in the Awards Table, which has 16 fields- 1 for each award. Each one assigned is a '0' for not awarded and a '1' for awarded.
What I need to know is how to set up the display so that when there are multiple images, it will display an image for EACH award.
I hope I explained that enough for you to help me here. Thanks guys in advance.
