on Linux I just grab it from mysql with a select:
Code:
--------------------
$query = "SELECT contributors.name, albums.title, albums.musicbrainz_id
FROM albums, contributors
WHERE albums.contributor = contributors.id
AND albums.artwork IS NOT NULL
AND strcmp(albums.musicbrainz_id, '')
ORDER BY contributors.namesort, albums.title";
--------------------
That only lists the things I have "properly" tagged and cleaned up and
have artwork for (so it does miss a bunch, but it's what I want :P), I
use the returned values from that to make HTML:
Code:
--------------------
$q = $dbh->prepare( $query ) ;
$rv = $q->execute();
while ( ($name, $title, $id) = $q->fetchrow_array )
{
print "<tr><td>$name</td>"
. "<td><a href=\"http://musicbrainz.org/album/$id.html\";>"
. "$title</a></td></tr>\n";
}
--------------------
--
snarlydwarf
------------------------------------------------------------------------
snarlydwarf's Profile: http://forums.slimdevices.com/member.php?userid=1179
View this thread: http://forums.slimdevices.com/showthread.php?t=22169
_______________________________________________
ripping mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/ripping
