Just analyze your query... You're requesting stuff where users.user_id equals awards.award_id... Even in the case it would return something it would probably not be what you want...
more expected joins are:
user.user_id = awards.user_id
user_awards.award_id = awards.ward_id
user_awards.user_id = user_id
Howto get multiple values from 1 row
Moderator: General Moderators