SET variables in JDatabaseQuery

by Midhat   Last Updated February 04, 2018 14:10 PM

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



Related Questions


Pass var to jQuery script

Updated June 26, 2015 12:20 PM



Get the menu item variable using Jinput

Updated March 27, 2015 05:03 AM

Params in Custom Component List View

Updated August 08, 2017 00:10 AM