Correct condition for multiple request?

Question

MySQL

SELECT fab_price.*, users.first_name, users.second_name, users.company FROM fab_price LEFT JOIN users WHERE fab_price.name = '$type_name' AND users.id = fab_price.parent_id

I have this code, it doesn't work. I think the jamb in the conditions, but not sure. Can you suggest how to make this request correctly?

Answer 1

SELECT fab_price.*, users.first_name, users.second_name, users.company FROM fab_price LEFT JOIN users ON users.id = fab_price.parent_id WHERE fab_price.name = '$type_name'