Syntax statements

[anevins]

I'm having problems with the syntax of my SQL statement and I don't know how to solve it.

 

SELECT * FROM stick, location, identification WHERE make LIKE '%$terms%' AND stick.sid = location.lid AND identification.stickID = stick.sid 
AND identification.id = $id"

 

The problem is when I add:

AND identification.id = $id

 

As I need to define what $id is.

 

How can I make a valid statement from this?

Thanks

[The Little Guy]

SELECT * FROM stick LEFT JOIN location ON(stick.sid = location.lid) LEFT JOIN identification ON(identification.stickID = stick.sid) WHERE make LIKE '%$terms%' AND identification.id = $id