Search code examples
phpdb2ibm-midrange

PHP - AS400 DB2 table uses $ at the start of the field name


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

Solution

  • 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.