php - How can i pair images in my DB? -

php - How can i pair images in my DB? -

i had hard time giving question title, hope im clear enough. im using php & html mysql database.

see have fellow member site, every new fellow member gets randomly chosen football game player avatar. football game player avatar assigned folder named 'avatars'. 1 time user registered, avatar moved folder named 'used_avatars'. every image named football game player, because want display name of chosen player on users fellow member page.

here's real question: want add together flag representing players nationality on fellow member site. have several brazilian players , 1 brazilian flag. how pair 5 players 1 flag. thinking of naming images "brazil-ronaldo", "brazil-carlos" , in way in php separating country name , match them flag , avatar. create sense? there improve way of doing this? guess need create new table in database keeps record of flag , avatar match?

hope helps:

you need table players containing field nationality id , table nationalities names flags.

this way can select player , bring together nationality via id.

all have save player id in user "profile".

php html mysql database