I'm joining a code description table to the table that has the code. Each field in the code description table starts with a $. PHP thinks these are variables and breaks. Is there a way to tell PHP these are field names and not variables?
Thank you
select $text FROM l0text where $code = 'XLST' and $value = c2xlst
I figured out how to do it:
$text = '$text';
$code = '$code';
$value = '$value';
By making variables with the same field name it allowed the sql to run correctly.