ERROR!
No lyrics were requested, please go back to the homepage and start again.
";
}
else {
$vote = $_REQUEST['vote'];
if($vote) {
$lookup_field = "votestar".$vote;
$get_values = mysql_query("SELECT votestar1, votestar2, votestar3, votestar4, votestar5 FROM tracks WHERE id = ".$j." LIMIT 1");
$votestar1 = mysql_result($get_values, 0, votestar1);
$votestar2 = mysql_result($get_values, 0, votestar2);
$votestar3 = mysql_result($get_values, 0, votestar3);
$votestar4 = mysql_result($get_values, 0, votestar4);
$votestar5 = mysql_result($get_values, 0, votestar5);
if($vote == 1) $votestar1 = $votestar1+1;
elseif($vote == 2) $votestar2 = $votestar2+1;
elseif($vote == 3) $votestar3 = $votestar3+1;
elseif($vote == 4) $votestar4 = $votestar4+1;
elseif($vote == 5) $votestar5 = $votestar5+1;
$total = ($votestar1 * 1)+($votestar2 * 2)+($votestar3 * 3)+($votestar4 * 4)+($votestar5 * 5);
$total = $total/($votestar1+$votestar2+$votestar3+$votestar4+$votestar5);
$update_joke = mysql_query("UPDATE tracks SET ".$lookup_field." = ".$$lookup_field.", votestartotal = ".$total." WHERE id = ".$j." LIMIT 1");
}
$lyricsqry = mysql_query("SELECT artist, album, title, dateadded, artwork, views, votestartotal FROM tracks WHERE id = ".$j." LIMIT 1");
if($lyricsqry) {
$artist = mysql_result($lyricsqry, 0, artist);
$album = mysql_result($lyricsqry, 0, album);
if(strlen($album) == 0) $album = "Unknown";
$title = mysql_result($lyricsqry, 0, title);
$dateadded = mysql_result($lyricsqry, 0, dateadded);
$dateadded = substr($dateadded, 8, 2)."/".substr($dateadded, 5, 2)."/".substr($dateadded, 0, 4);
$artwork = mysql_result($lyricsqry, 0, artwork);
$views = mysql_result($lyricsqry, 0, views);
$votestartotal = mysql_result($lyricsqry, 0, votestartotal);
$lyricsqry2 = mysql_query("SELECT lyrics FROM lyrics WHERE trackid = ".$j." LIMIT 1");
$lyrics = stripslashes(mysql_result($lyricsqry2, 0, lyrics));
$newviews = $views+1;
$update = mysql_query("UPDATE tracks SET views = ".$newviews." WHERE id = ".$j." LIMIT 1");
}
else die("ERROR LOOKING UP LYRICS");
$ptitle = strtoupper($title." lyrics - ".$artist);
$meta_keys = str_replace(" ", ", ", $title)." lyrics".", lyrics, new lyrics, online lyrics, latest lyrics, top lyrics, independant lyrics, artist lyrics, album lyrics, lyrics search";
//$meta_desc = $title." by ".$artist." lyrics";
$meta_desc = ($title." lyrics performed by ".$artist).". ".substr(strip_tags($lyrics), 0, 350)."...";
if($r == 1) $selected = "RANDOM";
else $selected = "VIEW";
include("header.php");
?>
Artist Listing:
";
echo "";
if($let == $letters[$i]) echo "";
echo $letters[$i];
if($let == $letters[$i]) echo "";
echo "";
if($let != $letters[$i]) echo "";
$i++;
if(($i == 15) || ($i == 27)) echo " | ";
else echo " | ";
}
?>
".$title." Lyrics
";
else echo "
"; ?>
".$album."
"; ?>
".$lyrics."
";
echo "$artist - $title Lyrics";
?>
More ".$artist.""; ?> Lyrics :
";
$tracker = 1;
while($row = mysql_fetch_array($temp)) {
echo "| ".$tracker.". | ".$row[title]." Lyrics |
";
$tracker++;
}
echo "
";
?>
Comments:
