T-String Error

[unemployment]

I get a t-string error.  Any thoughts?

 

$emp = 'SELECT employees.function FROM employees WHERE employees.userid=${r['id']}'; 

[DavidAM]

You are using single-quotes (around the array index "id") inside of a single-quote delimited string. The single-quote before "id" is ending your string, and the "id" is an unexpected string. Since you can't put a variable inside a single-quote delimited string, you need to delimit the string with double quotes:

 

$emp = "SELECT employees.function FROM employees WHERE employees.userid=${r['id']}";

[Pikachu2000]

And move the $ inside the curly braces . . . {$r['id']}