- appending two select dropdown menus to the same div
- "song 1" order # 2
- "song 2" order # 3
- "song 3" order # 1
- "song 1" order # 2 Key D
- "song 2" order # 3 Key A
- "song 3" order # 1 Key Eb
- $chart_query = mysql_query("SELECT id, title FROM songs WHERE team_name='$team_name' ORDER BY title ASC") or die();
- while($row = mysql_fetch_array($chart_query)){
- $song_id = $row['id'];
- $song_title = $row['title'];
- $song_chart .= '<div align="left" class="song_links">';
- if ($logOptions_id == $admin_id) {
- $song_chart .= '<div id="songChart'.$song_id.'" style="border-bottom:1px dotted gray;">
- <span class="selection">
- <select name="selection'.$song_id.'" class="selection">
- <option></option>
- <option value="01-'.$song_id.'&'.$song_title.'">1</option>
- <option value="02-'.$song_id.'&'.$song_title.'">2</option>
- <option value="03-'.$song_id.'&'.$song_title.'">3</option>
- <option value="04-'.$song_id.'&'.$song_title.'">4</option>
- <option value="05-'.$song_id.'&'.$song_title.'">5</option>
- <option value="06-'.$song_id.'&'.$song_title.'">6</option>
- <option value="07-'.$song_id.'&'.$song_title.'">7</option>
- <option value="08-'.$song_id.'&'.$song_title.'">8</option>
- <option value="09-'.$song_id.'&'.$song_title.'">9</option>
- <option value="10-'.$song_id.'&'.$song_title.'">10</option>
- <option value="11-'.$song_id.'&'.$song_title.'">11</option>
- <option value="12-'.$song_id.'&'.$song_title.'">12</option>
- <option value="13-'.$song_id.'&'.$song_title.'">12</option>
- <option value="14-'.$song_id.'&'.$song_title.'">14</option>
- <option value="15-'.$song_id.'&'.$song_title.'">15</option>
- </select>
- </span>
- <span class="key">
- <select name="selection'.$song_id.'" class="selection">
- <option></option>
- <option value="A">A</option>
- <option value="Bb">Bb</option>
- <option value="B">B</option>
- <option value="C">C</option>
- <option value="Db">Db</option>
- <option value="D">D</option>
- <option value="Eb">Eb</option>
- <option value="E">E</option>
- <option value="F">F</option>
- <option value="F#">F#</option>
- <option value="G">G</option>
- <option value="Ab">Ab</option>
- </select>
- </span>
- – <a href="http://' . $dyn_www . '/template.php?id='.$song_id.'" style="color:#9B1717; text-decoration:none;">'.$song_title.'</a> <img src="../images/loading.gif" id="chartDeletingpic'.$song_id.'" style="display:none;" /> <a href="#" onclick="deleteSongChart('.$song_id.')" style="color:gray; float:right; font-weight:100;">delete</a></div></div>';
- }
- $("#selectionBox select").change(function(){
- obj = {};
- obj.s = [];
- obj.k = [];
- $("#selectionBox .selection select option:selected").each(function(){
- $("#selected_songs").text('');
- v = $(this).val();
- if(v != ''){
- obj.s.push(v);
- }
- if(obj.s != ""){
- $('#selectionButton').show();
- var mw = $("#list_month_New").val();
- var dw = $("#list_day_New").val();
- var yw = $("#list_year_New").val();
- var t = $("#listTitle").val();
- if(mw == "" || dw == "" || yw == ""){
- $("#songListWarning").show();
- }else{
- $("#songListWarning").hide();
- }
- }else{
- $("#list_month_New").val();
- $("#list_day_New").val();
- $("#list_year_New").val();
- $("#listTitle").val();
- $('#selectionButton').hide();
- }
- });
- $("#selectionBox .key select option:selected").each(function(){
- v = $(this).val();
- if(v != ''){
- obj.k.push(v);
- }
- })
- obj.s.sort();
- jQuery.each(obj.s, function(){
- O = "";
- O = this+"<br />";
- str = /&(.+)/.exec(O)[1];
- num = O.replace(/-.*/, '');
- fullString = '<span style="color:black">'+num+'</span> - '+str;
- $("#selected_songs").append(fullString);
- });