Left Join query not working

[harkly]

Can someone take a look at my query? It was working until I add the 2nd Left Join.

 

Never had more that one Join in my quieries so not really sure of what I am doing.

 

         $query = ("SELECT user.userID, user.gender, user.bd_year, user.city, user.state, photos.userID, photos.photo_1, about_me.smoking,
                           CURDATE(), YEAR(CURDATE())-YEAR(birth_date)) - (RIGHT(CURDATE(),5)<RIGHT(birth_date,5)) AS age
                    FROM user
                    LEFT JOIN photos
                    ON user.userID = photos.userID
                    LEFT JOIN about_me
                    ON user.userID = about_me.userID
                    WHERE user.bd_year <= $year1 AND user.bd_year >= $year2 AND user.gender = $genderPref AND about_me.smoking = $smoke");

 

 

[Gamic]

What are you trying to show?

[harkly]

Thanks I got it to work.