Sort Categories in Ascending Order

[user55]

Hi,

How would I make the following display in ascending order?

<?php
$sql_category = " Select Distinct `Area`,`Area` From `sons` Order by `Area`";
$result_category = mysql_query($sql_category)
          or die("Invalid query");
$rowcount = mysql_num_rows($result_category);
if ($rowcount>0){
    $i=0;
    $css_class = "\"area\"";
    print "<div class=" . $css_class . ">";
	print "<ul>";
    print "<li><a href=\"sons.php?clearsession=1\">All</a></li>";

while ($row = mysql_fetch_row($result_category)){
    if ($row[1]=="") {
        $cellvalue = "&nbsp;";
    } else {
        $cellvalue = $row[1];
    }

    if (trim(strtoupper($row[0])) != trim(strtoupper(qssession("search_fd1"))))  {
        print "<li><a href=\"sons.php?search_fd1=".$row[0]. "&" . $sortstring."\"" . ">" .$cellvalue."</a></li>";
    } else {
        print "<b>".$cellvalue."</b>" ;
    }

    $i +=1;
} //==End while
print "</ul>";
print "</div>";
} // end if ($rowcount>0)
?>

Any help would be appreciated. Thanks!

Regards,

Sara

[alimadzi]

Ascending order of what? Area? Should be doing that already judging by your query.