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?

Searching on multiple rows
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Searching on multiple rows
#54405
Searching on multiple rows 8 Years, 11 Months ago Karma: 0
Good day,

I'm new with Ari Soft so I have a lot of questions. FOr now my I would like to know if it is possible to search on different rows.


I have a table with 6 coloms, one of these is Size and another one is Color. I would like to have the possibilty to searc for red (in color) and for M in size.

In general I would like to have a top row (for all columns) where I can put search items in.

I hope this is possible and would be pleased if you can tell me how to do this.

Best regards,
Gerrit Spilt
The administrator has disabled public write access.
 
#54408
Re:Searching on multiple rows 8 Years, 11 Months ago Karma: 747
Hello,

The extension doesn't support separate search by columns.

If you show data from a database, it is possible to create a search HTML form outside the module and send data from it to SQL query which is used by the module to retrieve data. Request parameters are used in "WHERE" clause of SQL query in the following way:

Code:


SELECT
 *
FROM
 tbl
WHERE
 size = {$REQUEST:size}



Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1