$query = "SELECT  artist_name,artist_id FROM artist";
$result = mysql_query($query) or die(mysql_error());
$array = mysql_fetch_array($result, MYSQL_BOTH);
$sorted = sort($array);
print "<ul>";
while ($row = $sorted ) {
   print "<li><a href=\"artist.php?artistid=$row[artist_id]\">$row[artist_name]</a></li>";
}
print "</ul>";