[mythtv-users] [PATCH] Mythweb -- Mythmusic playlist functionality AND Request for SQL help

[Ryan Steffes]

http://www.afferentsys.com/~rbsteffes/patch-mythmusic.bz2

This patch adds to the functionality I've been working on to add
playlist manipulation to mythweb.  Previously added was the ability to
create/rename/add to/remove from a playlist.  I've added reordering
playlists.

That brings me to the second part of the request.  If anyone out there
is particularly good at SQL I'm looking for a way to sort a select
statement against a known string.  The reason for this is because the
way mythweb gets track names is efficient from a query standpoint, it
gets them in the order of the intid key for the tracks in the db not
the order they are listed in the playlist.  It's because it retrieves
as where intid is in ( " playlist ") essentially.  Is there a way I
can have it sort against the playlist before returning the rows? 
That'd make playlist reordering look a lot better.

Right now, while it works, it doesn't appear to because the tracks
show up in database order, not playlist order.  If there isn't a good
way, there are work around fixes but they'd require more active
sorting and could get ugly fast.

Thanks

Ryan