I'm trying to write this querry:
SET @rownumber = 0;
UPDATE #__hikers SET rank = (@rownumber:=@rownumber+1)
ORDER BY score DESC;
like JDatabaseQuery, but still got an error. Please help
SET variables in JDatabaseQuery
Midhat
- 109
- 7