some codes relate to mySQL and php

[jackyhuphp]

my burnning question is how to display the columns from three tables one is the other two bridging table which used to resolve many to many relationship. (member, sport and memberSport)
$aSQL="select memberName, sportName from member sport memberSport where member.memberID=memberSport.memberID and sport.sportID=memberSport.sportID" but it's not working ! could someone tell me please what wrong is?

Many thanks

[vaaaska]

Oh my god that like hurts my brain looking at it! 😉

You might try:

// note my flagrant use of commas!

$aSQL="SELECT memberName,sportName 
FROM member,sport,memberSport 
WHERE member.memberID=memberSport.memberID 
AND sport.sportID=memberSport.sportID"