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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

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


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, 10 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, 10 Months ago Karma: 760
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, 10 Months ago Karma: 0
Thank you. Very good!
The administrator has disabled public write access.
 
Go to topPage: 1