A rank users order by points

Posted on 16th Feb 2014 07:03 pm by admin

I want to make an insert from table 'rank' , with number (rank) from the cod blow, to fild users.rank ...

set @rank := 0;
select @rank:=@rank+1 'rank', users.username, users.points from users order by points desc;
Code: +------+-------------+--------+
| rank | username | points |
+------+-------------+--------+
| 1 | ropy | 98 |
| 2 | alexcsandru | 17 |
| 3 | bobo | 17 |
| 4 | ovidiu | 5 |
+------+-------------+--------+
How to do??

P.S.: to insert rank in users.rank table... and with a function reload_player_rank() of 30 in 30 minutes (to update new rank in table users.rank) .


A solution please

Your Answer:

Login to answer

Other forums

Error in Configure System Landscape Directory phase
Hi

We are getting the error in Configure SLD phase ( 41 of 44 phase).

Please f

need help in creating captcha
hi i have a problem creating captcha system. i create some basic script for image displaying but it

Need help to modify php ELSE code
I'm trying to find a way to have the php code display a message if there is no inventory listed in t

help with multi-update
Now sure how to ask this really....
10g database if that matters.

I have a customer

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

Contents of variable not echoing
Hey guys, hopefully this is an easy one...

In this line, the variables are not echoing out. T

Polymorphism
Was wondering if someone could explain this a little better to me. I had always assumed that it had

Hit counter updating once per IP - IP HIT COUNTER
I have a hit counter, for the amount of views on a tutorial.
It'll do the query and then do..

IS Retail & Manufacturing
Hi

Can IS Retail and Manufacturing activities be done in same instance ie. in same client

chat
hello i'm amir i need a chat source code in asp.net 2.0 without Ajax. anybody can help me?