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

Other php-forum

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag

reating a background image
I am building a site in drupal and have a php form in it, due to certain annoyances with module buil

Error Messaging not working
I changed the way my form tells the user of an error. But I can't seem to get it to work properly.

Writing to the middle of a file
Hi I have a bit of a problem. Is there any way i can write some text to a middle of a text file. For

Secure pages Sessions vs. Cookies & session_destroy() help
Im new here and new to PHP, I hope you can help me with some questions.

Im writing my web ap

Query issues
I probably have this setup wrong well I know I do because nothing is showing up now. What I want is

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Blogging s/w 
heya frndz!!! i want to start a blog.... m looking for a s/w like oscommerce which is thr for e-comm
PHP5/Zend 2.0 - Resources 
PHP5 Snapshots

http://snaps.php.net/



ZEND 2.0 Feature Overview and Design (PDF File 
Log $_POST 
How would i log submits on a form, by everyone? I want to then echo the number of submissions.