How best to get someone’s ‘rank’ from a scores table with php and mysql without looping

by 
SELECT s1.initials, (
  SELECT COUNT(*)
  FROM scores AS s2
  WHERE s2.score > s1.score
)+1 AS rank
FROM scores AS s1

More Related Contents:

  1. How to update multiple MySQL table entries with different id?
  2. Can’t insert data into mysql database using PHP [closed]
  3. which is better every user have a table or just a row [closed]
  4. Warning: mysql_connect(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  5. How can I use PDO to fetch a results array in PHP?
  6. Fixing broken UTF-8 encoding
  7. MySQL check if a table exists without throwing an exception
  8. Export MySQL data to Excel in PHP
  9. Alternative to mysql_real_escape_string without connecting to DB
  10. HTML – Change\Update page contents without refreshing\reloading the page
  11. Calculate age based on date of birth
  12. How to write a stored procedure using phpmyadmin and how to use it through php?
  13. Doing calculations in MySQL vs PHP
  14. Geo-Search (Distance) in PHP/MySQL (Performance)
  15. Call to a member function execute() on boolean in [duplicate]
  16. PHP mysql search multiple tables using a keyword
  17. SQLSTATE[HY000] [1045] Access denied for user ‘username’@’localhost’ using CakePHP
  18. How do I count unique visitors to my site?
  19. Best practice: Import mySQL file in PHP; split queries
  20. ini_set, set_time_limit, (max_execution_time) – not working
  21. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  22. Setting a connect timeout with PDO
  23. How to build a JSON array from mysql database
  24. How to display a date as iso 8601 format with PHP
  25. How to generate unique id in MySQL?
  26. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  27. adding 30 minutes to datetime php/mysql
  28. Remotely connecting to a MySQL database
  29. Create table with PHP and populate from MySQL
  30. MYSQL select a piece of a string and order by that piece

Leave a Comment