How to make a MySql query faster?

MySQL and PHP Help with the Select Function?

• I am making a 'Richest Person List' on my Website. This is the Code: <div class="box2"> <p class="chat">Richest Person of the Month!</p> <br></br> <?php // Make a MySQL Connection $host = "CENSORED"; //db host $user = "CENSORED"; // username $pass = "CENSORED"; // password $database = "minecraft"; // forum db $conn = mysql_connect($host,$user,$pass) or die("Connection Denied."); $db = mysql_select_db($database,$conn) or die(mysql_error()); $query = "SELECT username, MAX(balance) FROM iconomy"; $result = mysql_query($query) or die(mysql_error()); // Print out result while($row = mysql_fetch_array($result)){ echo "The most richest is ". $row['username']. " with $" .$row['MAX(balance)']; echo " "; } ?> </div> Now, my EXPECTED result is: The Most Richest is (Richest Person's name) with $99999. The ACTUAL RESULT is: The Most Richest is (First Person on top of the MySQL Table) with $99999. How do I modify the code so that my EXPECTED result is my Actual Result? Additional Details: $query = "SELECT username, balance FROM iconomy WHERE balance = MAX(balance)"; and echo "The most richest is ". $row['username']. " with $" .$row['balance'] This won't work as it returns me with a 'Invalid use of group function' error.

• Answer:

  use sub query! select username, balance from iconomy where balance = (select max(balance) from iconomy) max() is an aggregate function so read more about aggregate functions to know how to use it correctly. http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html