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

Kevin Kuphal kuphal at dls.net
Wed Oct 27 16:23:43 UTC 2004

Ryan Steffes wrote:

>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
>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?


More information about the mythtv-users mailing list