// this is what i have now
$result = mysql_query("SELECT pages, name FROM links");
while (list($pages, $name) = mysql_fetch_row($result)) {
echo " \n" .
"<a href="$pages?id=$name" target="I1">$name</a><br>\n" .
"\n";
}
$result = mysql_query("SELECT pages, name FROM links ORDER BY pages");
or
$result = mysql_query("SELECT pages, name FROM links ORDER BY name");
or
$result = mysql_query("SELECT pages, name FROM links ORDER BY pages DESC");
or
$result = mysql_query("SELECT pages, name FROM links ORDER BY name DESC");