Posted by Alan Little on 05/18/06 14:35

Carved in mystic runes upon the very living rock, the last words of
Sjoerd of comp.lang.php make plain:

>> //$query = 'SELECT TITLE, NAME, INST, ADD1, ADDR2, ADDR3, PH, FAX,
>> EMAIL FROM officers WHERE GRP = $w';
>
> When a string is between 'single quotes', variables are not parsed.
> This means that after
> $query = 'SELECT $w'
> The variable query literaly contains SELECT $w. To use the value of
> the variable w instead, use double quotes:
> $query = "SELECT $w"
> This becomes SELECT and then the value of variable w.
>
> Another option is to use the concatination operator, which is a dot.
> $query = 'SELECT '.$w
> This way, the string 'SELECT ' and the variable w are concatenated
> together.

And don't forget to enclose the value in single quotes within the query:

"...WHERE GRP = '$w'";

--
Alan Little
Phorm PHP Form Processor
http://www.phorm.com/

[Back to original message]