input; $song = $jinput->get('song', '0', 'INT'); # Overview if (empty($song)) { $letter = array(array("a","d"),array("e","h"),array("i","l"),array("m","p"),array("q","u"),array("v","z")); ?>

".strtoupper($letter[$i][0])."~".strtoupper($letter[$i][1])." ] "; }?>

[ ]">
    getQuery(true); // Create array of alb_id's $q_tabs->select('lyr.*'); $q_tabs->from($db->quoteName('sophie_lyrics','lyr')); $q_tabs->where($db->quoteName('lyric_title') . " REGEXP '^[".$letter[$i][0]."-".$letter[$i][1]."]' "); $q_tabs->where($db->quoteName('lyric_tab'). " != '' "); $q_tabs->order('lyric_title ASC'); // Reset the query using our newly populated query object. $db->setQuery($q_tabs); // Load the results as a list of stdClass objects (see later for more options on retrieving data). $tabs_list = $db->loadObjectList(); foreach($tabs_list as $tab) { echo '
  • '.$tab->lyric_title.'
  • '; } ?>
0) { // Create a new query object. $q_tab = $db->getQuery(true); // Create array of alb_id's $q_tab->select('lyr.*'); $q_tab->from($db->quoteName('sophie_lyrics','lyr')); $q_tab->where($db->quoteName('lyric_id') . ' = '. $song); $q_tab->limit('0,1'); $db->setQuery($q_tab); $lyric_assoc = $db->loadAssoc(); // Create a new query object. $q_tab_alb = $db->getQuery(true); // Create array of alb_id's $q_tab_alb->select('*'); $q_tab_alb->from($db->quoteName('sophie_album_lyric_idx','idx')); $q_tab_alb->join('LEFT', $db->quoteName('sophie_lyrics','lyr') . ' ON idx_lyric = lyric_id'); $q_tab_alb->join('LEFT', $db->quoteName('sophie_albums','alb') . ' ON idx_album = alb_id'); $q_tab_alb->where($db->quoteName('lyric_id') . ' = '. $song); $q_tab_alb->where($db->quoteName('alb_type') . ' = '. "'album'"); $db->setQuery($q_tab_alb); $lyric_alb_obj = $db->loadObjectList(); // Create a new query object. $q_tab_sing = $db->getQuery(true); // Create array of alb_id's $q_tab_sing->select('*'); $q_tab_sing->from($db->quoteName('sophie_album_lyric_idx','idx')); $q_tab_sing->join('LEFT', $db->quoteName('sophie_lyrics','lyr') . ' ON idx_lyric = lyric_id'); $q_tab_sing->join('LEFT', $db->quoteName('sophie_albums','alb') . ' ON idx_album = alb_id'); $q_tab_sing->where($db->quoteName('lyric_id') . ' = '. $song); $q_tab_sing->where($db->quoteName('alb_type') . ' = '. "'single'"); $db->setQuery($q_tab_sing); $lyric_sing_obj = $db->loadObjectList(); // Create a new query object. $q_tab_pro = $db->getQuery(true); // Create array of alb_id's $q_tab_pro->select('*'); $q_tab_pro->from($db->quoteName('sophie_album_lyric_idx','idx')); $q_tab_pro->join('LEFT', $db->quoteName('sophie_lyrics','lyr') . ' ON idx_lyric = lyric_id'); $q_tab_pro->join('LEFT', $db->quoteName('sophie_albums','alb') . ' ON idx_album = alb_id'); $q_tab_pro->where($db->quoteName('lyric_id') . ' = '. $song); $q_tab_pro->where($db->quoteName('alb_type') . ' = '. "'promo'"); $db->setQuery($q_tab_pro); $lyric_pro_obj = $db->loadObjectList(); ?>

Song information

Written by:
Sample:
lyric_title)); ?>
Music video
Lyrics
View lyrics
Appears on:
alb_title,$album->alb_type,'250');?> alb_title,$album->alb_type,'250');?> alb_title,$album->alb_type,'250');?>

 
Go back to guitar tab index