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?

$REQUEST for multiple fields
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: $REQUEST for multiple fields
#56680
$REQUEST for multiple fields 8 Years, 3 Months ago Karma: 0
I have columns of database table with multiple fields.
When I use {$ RESTART: program} you can use LIKE% ...% in SQL Query after WHERE?
Thank you and greetings
The administrator has disabled public write access.
 
#56681
Re:$REQUEST for multiple fields 8 Years, 3 Months ago Karma: 747
Hello,

If you mean a request variable ({$REQUEST:program}), it can be used in SQL query in the following way:

SELECT
col1,
col2
FROM
tbl
WHERE
col1 LIKE CONCAT('%', {$REQUEST:program}, '%')

Regards,
ARI Soft
The administrator has disabled public write access.
 
#56683
Re:$REQUEST for multiple fields 8 Years, 3 Months ago Karma: 0
Thank you. Very good!
The administrator has disabled public write access.
 
Go to topPage: 1