1) || ($a)) { $start = $_REQUEST['start']; if (!$start) $start = 0; $page = $start + $s_perpage; $page = $page / $s_perpage; $ptitle = $c . " search - Page $page"; $meta_keys = "mp3, tunes, music, lyrics, singing, albums"; $meta_desc = $c . " search - Page $page"; $selected = "SEARCH"; include ("header.php"); if (!$a) { $temp3 = mysql_query("SELECT COUNT(id) AS total FROM tracks WHERE artist LIKE '%$c%' OR title LIKE '%$c%' OR album LIKE '%$c%'"); $temp = mysql_query("SELECT id, title, artist, artwork, views FROM tracks WHERE artist LIKE '%$c%' OR title LIKE '%$c%' OR album LIKE '%$c%' ORDER BY artist LIMIT $start, $s_perpage"); } else { $temp3 = mysql_query("SELECT COUNT(id) AS total FROM tracks WHERE artist = '$c'"); $temp = mysql_query("SELECT id, title, artist, artwork, views FROM tracks WHERE artist = '$c' ORDER BY artist LIMIT $start, $s_perpage"); } $total = mysql_result($temp3, 0, total); ?>
" . $total . " results for '" . $c . "':

"; echo "Your search results are displayed below:

"; ?>
0) { echo ""; $tracker = $start + 1; while ($row = mysql_fetch_array($temp)) { if (($tracker % 2) == 1) echo ""; echo ""; if (($tracker % 2) == 0) echo ""; $tracker++; } echo "
"; echo show_artwork($row[id], 45); echo "" . $tracker . ". " . $row[artist] . "

" . stripslashes($row[title]) . "
view lyrics  (" . $row[views] . " views)

"; } else echo "
 - There are no results for your search criteria, please try again."; ?>
$s_perpage) { $start2 = $start - ($s_perpage * 2); if ($start2 < 0) $start2 = 0; echo "< Previous Page  "; } if ($start < $total) echo "  Next Page >"; ?>


Search For Lyrics:

"; echo "Use the searh box below to search for lyrics on this site. The artist, album and track title are all searched.

"; ?>
"; echo "Criteria:  "; echo ""; echo "

"; } include ("footer.php"); ?>