|
I can't figure out the LIKE operator as it relates to the input field on the webpage.
I can get this query to work:
SELECT firstname AS FirstName, lastname AS LastName, cb_phone AS Phone, cb_address AS Address, cb_address2 AS Address2, cb_city AS City,cb_state AS State, cb_zip AS Zip
FROM joom_comprofiler
WHERE
firstname LIKE '%am%’
But if I try to get the query to pull from the field on the webpage where I input AM I get no results for:
SELECT firstname AS FirstName, lastname AS LastName, cb_phone AS Phone, cb_address AS Address, cb_address2 AS Address2, cb_city AS City,cb_state AS State, cb_zip AS Zip
FROM joom_comprofiler
WHERE
firstname LIKE '%{$REQUEST:start|empty:''}%'
Any help is greatly appreciated.
Thank you for helping us with this,
Tk
|
