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

[Kevin Kuphal]

Ryan Steffes wrote:

>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.
>  
>
Wouldn't it be easier to sort them using PHP where you probably have 
alot more options and let the query execute as fast as possible the way 
it does now?

Kevin