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?

how to filter table by a to z (via link)
(1 viewing) (1) Guest
Go to bottomPage: 123
TOPIC: how to filter table by a to z (via link)
#42572
how to filter table by a to z (via link) 10 Years, 12 Months ago Karma: 0
how to filter table by a to z (via link)
A to z are link. When I click on link table should filter by A.
The administrator has disabled public write access.
 
#42573
Re:how to filter table by a to z (via link) 10 Years, 12 Months ago Karma: 748
Send your order number by email please.

Regards,
ARI Soft
The administrator has disabled public write access.
 
#42574
Re:how to filter table by a to z (via link) 10 Years, 12 Months ago Karma: 0
I have sent you order no.
The administrator has disabled public write access.
 
#42575
Re:how to filter table by a to z (via link) 10 Years, 12 Months ago Karma: 748
Do you show data from a database or a CSV file?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#42576
Re:how to filter table by a to z (via link) 10 Years, 12 Months ago Karma: 0
from database..
The administrator has disabled public write access.
 
#42577
Re:how to filter table by a to z (via link) 10 Years, 12 Months ago Karma: 748
It is possible to use request variables in "WHERE" clause of SQL query. Request variables are used in the following format:

{$REQUEST:VAR_NAME}

Where VAR_NAME is a name of request variable. For example if you want to use "city" request variable in SQL query, query will look like:

SELECT
*
FROM
tbl
WHERE
user_city = {$REQUEST:city}

For your case you can create a A - z links outside the module and send selected letter as a request variables and use it in "WHERE" clause of your SQL query.

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