Alpha Order

[Stevan]

I have a script that I want to have it add in Alpha order . I can not figure out how to do it a bit beyond what I have learned

 

##-----------------------------------------------------------------------------------

## GENERATING CATEGORY LIST -- START HERE

##-----------------------------------------------------------------------------------

$dir = '';

if (mysql_num_rows($rs) > 0)

{

$dir = '<tr><td align=\'left\' valign=\'top\' width=\'100%\'><ol>';

while (list($id,$name,$image) = mysql_fetch_row($rs))

{

$url = trim(strtolower($name)).'.html';

$url = str_replace(' ','',$url);

 

if ($image != '')

$dir .= "<p><li><a href='$url'><img src='images/$image' border=0><br><strong>$name</strong></a></li></p>";

else

$dir .= "<p><li><a href='$url'><strong>$name</strong></a></li></p>";

}

 

$dir .= '</ol></td></tr>';

}

 

return $dir;

}

 

?>

 

 

THXS Steve

[mainewoods]

if you want your list to print out in alphabetical order, what you have to do is to alter the sql of the query which resulted in $rs and add a clause to it to have the sql do the sorting for you.  You add a clause like this:

ORDER BY col_name  [ASC | DESC]

so we get an sql something like this:

$sql = "SELECT * FROM mytable WHERE (some condition here) ORDER BY name ASC";