We have a master list of hundred songs we can draw from in our database. I have already created a php / mysql / ajax (maybe not needed here) combination which populates the page with a table of a master list of items.
Currently when the worship leader clicks on the name of the song it is moved to a new table, and then that list gets placed in a database and emails get sent to the appropriate people. I need the list to do a little more. Two things I can't quite wrap my head around: In the master list I would like to be able to get jquery to filter the master table by letter. i.e. songs starting with Q only with the added ability to show all again... Of course if the last song with Q was just selected the list should automatically go back to showing all. I was doing this with Ajax, but feel this is a waste as jQuery can handle this directly. After the list is in the new table I would like to be able to do something like: http://www.lukedingle.com/javascript/sortable-table-rows-with-jquery-draggable-rows/
