Visit my Discogs listings to purchase any of these records or email me (trade _ at _ andrewmabbott _ dot _ org)
Order by: Artist | Title | Label | Cat. no | Year | Country
mysql_connect('localhost','andrew','elixir'); mysql_select_db('vinyl'); if(isset($_GET['order'])) { $order = $_GET['order']; if(!($order=='artist' || $order=='title' || $order=='country' || $order=='year' || $order=='label' || $order=='cat_no' )) { $order='artist'; } } else { $order = 'artist'; } $filters='WHERE available=1 '; if(isset($_GET['label'])) { $label = $_GET['label']; $filters.="AND label LIKE '%$label%' "; } $catalogue = mysql_query(" SELECT release_id, cat_id, label, cat_no, artist,title, country, year, alias FROM `release` $filters ORDER BY $order ASC"); while(list($releaseId,$catId, $label, $catNo, $artist, $title, $country, $year, $alias) = mysql_fetch_array($catalogue)) { $tracklist = mysql_query("SELECT track_title, filename FROM track WHERE release_id = $releaseId ORDER BY track_no ASC"); ?>