Sorting array from base

[Zilemir]

Hi how can i fist select on field frome base then foreach field set value to array then sort from highest to lowest number and then print the 5 highest number i have tryed here is code:

$user="xxxx";
$password="xxxx";
$database="xxxx";
mysql_connect("localhost",$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM files";
$result=mysql_query($query);

$num= mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"file_dls");
$statsarray=array($i => $first); 
$i++;



}

$i=0;
for ($i; $i <= 2; $i++){ //prints the array elements
    echo $statsarray[$i]."<br \>"; 
$i++;
}

can anybody help?

[GingerRobot]

You've lost me slightly, but if you're trying to sort items that are coming from a database, you should have the database do the sorting. E.g.:

 

SELECT field1,field2 FROM yourtable WHERE field1 < somevalue ORDER BY field2 DESC

[RussellReal]

what field r u sorting by?

 

try this as your query replace `field` with the field name

 

SELECT * FROM `files` ORDER BY `field` DESC