Miscellany

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