='”.$_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();
?>
