I'm trying to write this querry:
SET @rownumber = 0; UPDATE #__hikers SET rank = (@rownumber:[email protected]+1) ORDER BY score DESC;
like JDatabaseQuery, but still got an error. Please help