ARI Soft - Static row number

Featured Demos

e-mail: info@ari-soft.com

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.

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

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

Static row number

(1 viewing) (1) Guest

Page: 1

TOPIC: Static row number

Forum Tools

#29115

Static row number 12 Years, 5 Months ago	Karma: 0
Hi, Sorry for poor English. How can i add column with static row number. I want to put static row count (ordinal number) in one column. In the remaining columns will be data from the SQL database. Thanks in advance

pszemyk

The administrator has disabled public write access.

#29162

Re:Static row number 12 Years, 5 Months ago Karma: 760

Hello,

You can use user-defined variables. A sample SQL query:

Code:



SELECT 

  @rownum:=@rownum+1 AS position,

  id,

  title 

FROM 

  (SELECT @rownum:=0) AS pos,

  #__content

Regards,
ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links