besly98 Posted July 1, 2009 Share Posted July 1, 2009 Hi all, I was wondering if someone can help me. I ha ve a league table that i want to numbe rth epositions.. eg 1,2,3,4,5 to show where people ar ein the league. i cant find anything that will help me do this. does anyone know? thanks Quote Link to comment Share on other sites More sharing options...
trq Posted July 1, 2009 Share Posted July 1, 2009 Can we at least get an idea of what your table looks like? Quote Link to comment Share on other sites More sharing options...
runnerjp Posted July 1, 2009 Share Posted July 1, 2009 all depends on how you add up the scores or what ever you determin the place in the league... something like Select * from leaguetable ORDER BY 'position' Quote Link to comment Share on other sites More sharing options...
besly98 Posted July 1, 2009 Author Share Posted July 1, 2009 it will be ordered by points which are saved in that database. so like the highest points will be at the top.. etc. just basicaly like a football league table. does that explain? Quote Link to comment Share on other sites More sharing options...
runnerjp Posted July 1, 2009 Share Posted July 1, 2009 yer so what ever the table is order by it within the aql statement as shown above Quote Link to comment Share on other sites More sharing options...
trq Posted July 1, 2009 Share Posted July 1, 2009 Yeah that explains. Now, runnerjp's example should help you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.