0 Replies Latest reply on Sep 8, 2008 4:58 AM by Robert Hayes

    Create a PHP recordset from $_Get

    Robert Hayes
      I am sending a the URL variable ?code=(140,141), so the SQL statement should read:
      SELECT * from INVENTORY where code in (140,141)

      In the advanced area of the recordseI creater, I created the variable "colname" with the value $_GET['code'] and entered this statement directly into the text area.
      SELECT * from INVENTORY where code in colname
      The SQL statement seems to work OK using literal values but not when using the $_GET variable.

      Thanks for any advice or comments

      Robert Hayes