Searching with LIKE

not working with variable

[FromBelgium]

I try to return names starting with "A" from a MySQL database.

When I add LIKE 'A%' in the query it works, but when I first define the variable $letter="A" and then use LIKE '$letter%' it returns all values, not only those starting with "A". How can I use a variable with LIKE?

UPDATE:
Problem solved in the meantime. Stupid mistake: I put "$letter" in query string instead of "letter".

[coopster]

FromBelgium,

Make sure you put "letter" in the query string instead of "$letter".

Just kidding ;)
Glad you got it sorted.