Need help with LEFT JOIN

[Hamlets666]

Here is the code:

SELECT f.*, p.post_time, p.post_username, u.username, u.user_id
FROM (( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id)
LEFT JOIN " . USERS_TABLE . " u ON u.user_id = p.poster_id)

 

Thing I want to add is a check, i want to select data from all those tables there gothic_forum_id is equal to $gf :

 

WHERE f.gothic_forum_id = $gf AND  p.gothic_forum_id = $gf AND  u.gothic_forum_id = $gf 

 

Where shuld write it? I tried some ways and goth sql error.

 

 

 

[fenway]

Well, I'm confused about those parens... you don't need any of them, except maybe around the ON clause, for clarity.  Once you've done that, the WHERE clause should go at the end, as usual.