PHP - How to get, and display the biggest values from a database?

Posted by Dodi300 on Stack Overflow See other posts from Stack Overflow or by Dodi300
Published on 2010-04-16T18:59:10Z Indexed on 2010/04/16 19:03 UTC
Read the original article Hit count: 243

Filed under:
|
|
|

Hello. Can anyone tell me how to get and display the biggest values from a database? I have multiple values in my database with the heading "gmd", but how would I get only the first 3 biggest ones to be displayed? How would I do it in this example:

$query  = "SELECT gmd FROM account";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
}

Thanks.

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql