|
The problem is that the tables are created correctly there should be 3 tables, a member, a games, and another with games_member. Then it would be easier to do.
But from what you have you can make a second query collecting the names and then use it like this, fetching the results with mysql_results:
print "Games for ".mysql_results($results,id,'Username') ." are:".'<br/>';
print "Game 1 = ".mysql_results($results2,mysql_results($results,id,'Game1'),'GameName') .'<br/>';.
...
|