Thanks
I entered the new code
and does not even rank

We can't reproduce this problem on our test server. The rank is shown fine:



Regards,
ARI Soft

Thanks for the reply
I do not know where the problem is
I had to move (SELECT @curRank = 0) r
Code:

SELECT tc1,tc4,min,tc2,avatar,username,@curRank := @curRank + 1 AS Rank
FROM
(SELECT a.tc1, a.tc4, min(a.tc5) AS min, a.tc2, b.avatar, c.username, @curRank := @curRank + 1 AS Rank
FROM
sbhgl_chronoengine_chronoforms_datatable_treningove_casy a INNER JOIN
sbhgl_jsn_users b ON a.user_id=b.id INNER JOIN
sbhgl_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 min ASC) T


and now displays the rank of the picture

I figured it out
@curRank := @curRank + 1 AS Rank must be +0
Code:

SELECT tc1,tc4,min,tc2,avatar,username,@curRank := @curRank + 1 AS Rank
FROM
(SELECT a.tc1, a.tc4, min(a.tc5) AS min, a.tc2, b.avatar, c.username, @curRank := @curRank + 0 AS Rank
FROM
sbhgl_chronoengine_chronoforms_datatable_treningove_casy a INNER JOIN
sbhgl_jsn_users b ON a.user_id=b.id INNER JOIN
sbhgl_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 min ASC) T

now appears correctly thanks for great support

Hello
There is another problem tc1 and tc2 does not display the correct data

Could you explain in more details what is incorrect?

Regards,
ARI Soft