Help me!

[falfool]

Hi all, im having a little problem
check this code and read below it:

            $sql = "select choice1_hits, choice2_hits, choice3_hits, choice4_hits
                  from poll";
            $result = mysql_query($sql) or die (mysql_error());
            
            $row = mysql_fetch_array($result);
            
            $max = $row["choice1_hits"];
            if ($max < $row["choice2_hits"]) {
                  $max = $row["choice2_hits"];
            }
            if ($max < $row["choice3_hits"]) {
                  $max = $row["choice3_hits"];
            }
            if ($max < $row["choice4_hits"]) {
                  $max = $row["choice4_hits"];
            }

I want to get the numbers from the greatest to the smallest, please help me in this... Any help is most appreciated.. thanks guys

[Archbob]

It looks from that code your just trying to draw out the max value instead of the greatest to smallest.

[falfool]

Well, as i said, i need a way to get all of the values... then output them, please give me a piece of code! im in serious trouble

[Mike]

$array = array("Choice 1" => $row["choice1_hits"], "Choice 2" => $row["choice2_hits"], "Choice 3" => $row["choice3_hits"], "Choice 4" => $row["choice4_hits"]);
sort($array, "SORT_NUMERIC");
reset($array);
while (list ($key, $val) = each ($array)) {
    echo $key . ': ' . $val . "<br />\r\n";
} 

From the PHP manual, modified a bit.

[falfool]

thanks alot, i really appreciate ur help

[falfool]

oh... it didnt work! guys, this script is a poll.. i want to print the results frmo the highest to the lowest WITH their names! i have the names fetched from the $row, eexample
$row["choice1"] => $row["choice1_hits"] etc. so please hepl me doing this...