Song Info to show all the categories a song is a member of

tjoebgen · **Joined:** January 1st, 2009, 8:50 pm **Posts:** 107

Would like to have a place in Song Info that shows all of the categories that particular Song ID is in.

FesterHead · **Posted:** November 9th, 2009, 1:10 pm

Good idea and requested every so often.
A work-around is to display it on a website using a category lookup.

tjoe · **Joined:** November 14th, 2007, 1:09 am **Posts:** 4

FesterHead wrote:

A work-around is to display it on a website using a category lookup.

Oh? do tell? I did a search just now for "category lookup". Where might I find this talked about? Might help me in the short-term.

FesterHead · **Posted:** November 9th, 2009, 4:51 pm

Here's some (MySQL) SQL to get the categories for a given song id in ascending sort order:

Code:

select name from category c, categorylist cl where cl.songid = <insert_song_id_here> and cl.categoryid = c.id order by c.name asc