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: "; ?> |
| "; echo show_artwork($row[id], 45); echo " | " . $tracker . ". " . $row[artist] . " " . stripslashes($row[title]) . " view lyrics (" . $row[views] . " views) | ";
if (($tracker % 2) == 0)
echo "
|
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. "; ?> |