Advertisement
GaMeRFoReVeR

Untitled

Sep 5th, 2015
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.43 KB | None | 0 0
  1. <?php
  2. include_once("connect_db.php");
  3.  
  4. $sql = "set @x = 0;# MySQL returned an empty result set (i.e. zero rows).\n"
  5.     . "\n"
  6.     . "update stats A\n"
  7.     . "inner join\n"
  8.     . "(\n"
  9.     . " select @x:=@x+1 newposition,nick\n"
  10.     . " from stats\n"
  11.     . " order by score DESC\n"
  12.     . ") B using (nick)\n"
  13.     . "set A.score_rank=B.newposition;# 16 rows affected.\n"
  14.     . "";
  15.  
  16. if(mysql_query($sql))
  17.     echo 'Bravo';
  18. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement