[SOLVED] Wildcard

[wemustdesign]

I am doing a query but the wildcard does not work when I use a variable for a wildcard, not sure if its the syntax.

 

Works like this:

 

$sql = "SELECT * FROM cocktails WHERE name LIKE 'a%' ORDER BY name ";

 

Doesnt work when I use a variable though:

 

$sql = "SELECT * FROM cocktails WHERE name LIKE '$get_letter%' ORDER BY name ";

 

 

[premiso]

$sql = "SELECT * FROM cocktails WHERE name LIKE '{$get_letter}%' ORDER BY name ";

 

Try that.

[wemustdesign]

That sorted the problem thanks!