Stevan Posted March 6, 2008 Share Posted March 6, 2008 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 Quote Link to comment Share on other sites More sharing options...
mainewoods Posted March 6, 2008 Share Posted March 6, 2008 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"; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.