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

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

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

Song information

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

 
Go back to lyrics index