$query = "SELECT  artist_id,artist_id FROM artist ORDER BY artist_name";
$result = mysql_query($query) or die(mysql_error());
$array = mysql_fetch_assoc($result);
print "<ul>\n";
foreach($array as $row) {
   print "\n<li><a href=\"artist.php?artistid=$array[artist_id]\">$array[artist_name]</a></li>\n";
}
print "</ul>\n";