Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 18/11/2017 Black Friday is coming

    Don't wait BLACK FRIDAY, use FRIDAY17 coupon code to get 35% discount for all our extensions right now.

  • 05/09/2017 BIG Autumn SALE

    Use AUTUMN17 coupon code to buy our WordPress or Joomla! extensions with 25% discount. Hurry up! The offer is valid till 11 September.


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?

Problem making the module work
(1 viewing) (1) Guest
Go to bottomPage: 12345678
TOPIC: Problem making the module work
#59222
Re:Problem making the module work 1 Year ago Karma: 0
Hello
thanks for the help.
I still needed help with arranging table Rank.
according to the image
code
SELECT user_id , tc1 , tc4 , MIN( tc5 ) , tc2, @curRank := @curRank + 1 AS Rank
FROM
#__chronoengine_chronoforms_datatable_treningove_casy,(SELECT @curRank := 0) r
WHERE `tc2` LIKE 'Motokáry Modrice'
ORDER BY tc5 ASC
GROUP BY user_id

Last Edit: 2016/12/15 09:22 By mkcup.
The administrator has disabled public write access.
 
#59229
Re:Problem making the module work 1 Year ago Karma: 0
please, give me an advice
The administrator has disabled public write access.
 
#59235
Re:Problem making the module work 12 Months ago Karma: 670
Try the following query:

SELECT user_id , tc1 , tc4 , MIN( tc5 ) , tc2, @curRank := @curRank + 1 AS Rank
FROM
#__chronoengine_chronoforms_datatable_treningove_casy,(SELECT @curRank := 0) r
WHERE `tc2` LIKE 'Motokáry Modrice'
GROUP BY user_id
ORDER BY MIN(tc5) ASC

Regards,
ARI Soft
The administrator has disabled public write access.
 
#59237
Re:Problem making the module work 12 Months ago Karma: 0
Hello thanks
still ranks by ID

Last Edit: 2016/12/18 08:55 By mkcup.
The administrator has disabled public write access.
 
#59238
Re:Problem making the module work 12 Months ago Karma: 0
When I type ORDER BY min (a.tc5)
error appears: the image

once again send the entire code:

SELECT a.tc1, a.tc4, min(a.tc5), a.tc2, b.avatar, c.username, @curRank := @curRank + 1 AS Rank
FROM
#__chronoengine_chronoforms_datatable_treningove_casy a INNER JOIN
#__jsn_users b ON a.user_id=b.id INNER JOIN
#__users c ON a.user_id=c.id , (SELECT @curRank := 0) r
WHERE a.tc2 LIKE 'Motokáry Modrice'
GROUP BY a.user_id
ORDER BY a.tc5 ASC

Last Edit: 2016/12/18 08:57 By mkcup.
The administrator has disabled public write access.
 
#59239
Re:Problem making the module work 12 Months ago Karma: 670
Could you send an SQL dump of tables which is used in your query by email so we can investigate the problem on our test server?

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