Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Search firstname column problem
(1 viewing) (1) Guest
Go to bottomPage: 12
TOPIC: Search firstname column problem
#50663
Re:Search firstname column problem 9 Years, 8 Months ago Karma: 0
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
The administrator has disabled public write access.
 
#50665
Re:Search firstname column problem 9 Years, 8 Months ago Karma: 746
Use something like:

Code:


LIKE CONCAT('%', {$REQUEST:start|empty:''}, '%')



Regards,
ARI Soft
The administrator has disabled public write access.
 
#50666
Re:Search firstname column problem 9 Years, 8 Months ago Karma: 0
THANK YOU THANK YOU THANK YOU!!!
That worked and I got both first and last name queries working!
Thanks,
TK
The administrator has disabled public write access.
 
Go to topPage: 12