I've setup the ability for members to select their favorite games. I probably could have built this better from a database design point of view so I'm open to suggestions there.
Aside from that I'm trying to build a query that provides me with counts of the games so I can determine which is the most popular choice.
I can easily return the values of the first favorite game, but once I start to get all of them I have issues because I need to make a join that is apparently eluding my newness to PHP/MYSQL.
The field information is below.
Any help is much appreciated.
id > (persons.favorite_game_xx)