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?

Table in reverse order
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Table in reverse order
#14082
Table in reverse order 13 Years, 2 Months ago Karma: 0
Hello,

The data that is pulled from the SQL database appears in the ARI Data Table in reverse order. How can you sort or order the information before it appears in the Data Table?

thanks in advance!
The administrator has disabled public write access.
 
#14083
Re:Table in reverse order 13 Years, 2 Months ago Karma: 748
Hello,

You can use "ORDER BY" clause for SELECT query. For example if you want to select all data from tbl1 and sort it by col1 in descending order, use the next code:

Code:


SELECT
 *
FROM
 tbl1
ORDER BY
 col1 DESC



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