Search Results

='”.$_POST[‘name_start’].”‘ AND a.ARTIST <= '".$_POST['name_end']."') ORDER BY a.artist ASC"; } elseif (!empty($_POST['title_start'])) { $GetData=" SELECT a.*, b.date FROM voldesc a INNER JOIN releasedate b ON a.volume = b.volume WHERE (a.TITLE >= ‘”.$_POST[‘title_start’].”‘ AND a.TITLE <= '".$_POST['title_end']."') ORDER BY a.TITLE ASC"; } elseif (!empty($_POST['title'] )) { $GetData=" SELECT a.*, b.date FROM voldesc a INNER JOIN releasedate b ON a.volume = b.volume WHERE a.TITLE LIKE '%".$_POST['title']."%' ORDER BY a.VOLUME ASC"; } elseif (!empty($_POST['volume_low'] )) { $GetData=" SELECT a.*, b.date FROM voldesc a INNER JOIN releasedate b ON a.volume = b.volume WHERE (a.VOLUME >= ‘”.$_POST[‘volume_low’].”‘ AND a.VOLUME <= '".$_POST['volume_high']."') ORDER BY a.VOLUME ASC"; } elseif (!empty($_POST['label'] )) { $GetData=" SELECT a.*, b.date FROM voldesc a INNER JOIN releasedate b ON a.volume = b.volume WHERE a.label LIKE '".$_POST['label']."%' ORDER BY a.volume ASC"; } else { $GetData=" SELECT a.*, b.date FROM voldesc a INNER JOIN releasedate b ON a.volume = b.volume WHERE a.Volume = ".$_GET['volume']." ORDER BY a.Track ASC"; } //echo $GetData; $search_results=mysql_query($GetData); mysql_close(); ?>




Search Results:

Volume
   Release Date:

Vol Trk Artist Title Time Label
back Back to Search back Main Menu

Leave a comment

Your email address will not be published.