Home News Contact Us Forum About Us Demos Products F.A.Q.
ARI Soft









Register   Lost Password?
Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin







e-mail: info@ari-soft.com
Shopping Cart
You currently have 0 items in your cart.
Show 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. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?
Go to bottomPage: 1
TOPIC: Auto numbering
*
#30324
Auto numbering 12 Years, 8 Months ago Karma: 0
Can I insert autonumbering first column, when I get data from Joomla database?
ivo75
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#30329
Re:Auto numbering 12 Years, 8 Months ago Karma: 763
Hello,

If you show data from MySQL database, you can use RANK() function. The sample can be found here.

Regards,
ARI Soft
admin
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#30330
Re:Auto numbering 12 Years, 8 Months ago Karma: 0
Hi I use this SQL string
Code:

SELECT  id,  title 
FROM  #__content
WHERE  catid =16 AND state=1
ORDER BY id DESC


how to use this string with RANK()
ivo75
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#30332
Re:Auto numbering 12 Years, 8 Months ago Karma: 763
Try something like this:

Code:

SELECT  
  (@curRank := @curRank + 1) AS Rank,
  id,  title 
FROM  #__content, (SELECT @curRank := 0) r
WHERE  catid =16 AND state=1
ORDER BY id DESC


Regards,
ARI Soft
admin
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#30333
Re:Auto numbering 12 Years, 8 Months ago Karma: 0
Thanks, You are great it's work for me
ivo75
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
ARI Soft Forum
Joomla components
ARI Data Tables
Powered by Kunenaget the latest posts directly to your desktop
Useful Links
Products
F.A.Q.
Discount
RSS
Top Products
ARI Data Tables
ARI Sexy Lightbox
ARI Quiz
ARI Stream Quiz - Personal
ARI Smart Content
Help
Forum
F.A.Q.
Home | News | Contact Us | Forum | About Us | Demos | Products | F.A.Q.
ARI Soft
License | Terms and Conditions | Copyright Info | Privacy Policy
 
ARI Soft
Copyright © 2009