Howto get multiple values from 1 row

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

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
Post Reply