[SOLVED] Join Trouble

[kingnutter]

Hi there,

 

Can anyone tell me if I have the wrong syntax in this query. It doesn't seem to be working.

 

If there is no error in the query I shall post further information.

 

Thanks.

KN

 

$query="SELECT moj_genre FROM genres, genrelinkcd WHERE genres.genre_id = genrelinkcd.genre_id WHERE genrelinkcd.moj_id='$id'";
[code]

[kingnutter]

Sorry this is what I aiming at (but it still doesn't work):

 

$query="SELECT moj_genre FROM genres WHERE genres.genre_id = genrelinkcd.genre_id WHERE genrelinkcd.moj_id=$id";

 

I want to select field 'moj_genre' from the table 'genres' where genre_id in the same table is the same as genre_id in table 'genrelinkcd', but only where 'moj_id' in that table is equal to $id.

 

Phew.

[kingnutter]

$query="SELECT moj_genre FROM genres INNER JOIN genrelinkcd ON genres.genre_id=genrelinkcd.genre_id WHERE genrelinkcd.moj_id='$id'";