mind.in.a.box ordering:
if your local record store doesn't offer mind.in.a.box CDs,
these are some possibilities for ordering. if you have further
suggestions, please let us know!
  "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } elseif ($GameCounter == 1) { $GameCounter = 999; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>
   
 
"; echo ""; echo "Compilations"; echo ""; echo "
"; echo ""; echo ""; echo "
"; echo ""; echo "Games"; echo ""; echo "
"; echo ""; echo ""; echo "
  "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo ""; echo $row["ReleaseName"]; echo ""; echo "
"; echo ""; echo $row["ReleaseInfo"]; echo ""; echo "
 
"; echo ""; echo "Releasedate: ".$row["ReleaseDate"]; echo ""; echo "
"; echo ""; $tracks=mysql_fetch_array(mysql_query("select count(track) as tz from release_daten where id_r = '$row[id_r]'" )); if ($row["Compilation"] == 0) { echo "Tracks: ".$tracks["tz"]; } echo ""; echo "
"; echo ""; $geserg=mysql_query("select Laenge from tracks t, release_daten r where r.kuenstler='miab' and r.id_r='$row[id_r]' and r.kuenstler = t.kuenstler and r.id_d = t.id_d"); $gesamt = 0; while ($res = mysql_fetch_array($geserg)) { $gesamt = $gesamt + TimeToSec($res["Laenge"]); } if ($gesamt > 0 ) { $gesamt = SecToTime($gesamt); if ($row["Compilation"] == 0) { echo "Total play time: ".$gesamt; } } echo ""; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; $onlinestores=mysql_query("select id_r, region,link_nr,LinkName,link from release_links rl where rl.id_r='$row[id_r]' order by rl.link_nr"); while ($rowliste=mysql_fetch_array($onlinestores)) { echo ""; echo ""; } echo ""; echo ""; echo ""; } echo "
"; echo ""; echo "Onlinestores
"; if ($row["Compilation"] == 0 ) { if(isset($rowliste["region"])) echo $rowliste["region"]; echo ""; echo ""; echo " "."".$rowliste["LinkName"].""; echo ""; echo ""; $checklyrics=mysql_fetch_array(mysql_query("select t.Lyrics,t.DemoLink,d.Nr from tracks t, release_daten d where t.id_d='$rowliste[id_d]' and d.id_d = t.id_d and d.id_r='$row[id_r]' ")); if ($checklyrics["Lyrics"] > "") { echo " |Lyrics"; } else if ($checklyrics["Lyrics"] == "" and $row["Compilation"] == 0 ) { $checklyrics=mysql_fetch_array(mysql_query("select t.Lyrics,t.DemoLink,d.Nr from tracks t,tracks tt, release_daten d WHERE d.id_r = '$row[id_r]' and t.id_d = tt.RemixVon and tt.id_d = '$rowliste[id_d]' ")); if ($checklyrics["Lyrics"] > "") { echo " |Lyrics"; } } echo ""; echo ""; if ($checklyrics["DemoLink"] > "" and $checklyrics["Nr"] != 0) { echo " |Demo"; } else if ($checklyrics["DemoLink"] > "" and $checklyrics["Nr"] == 0) { // echo " |Tracklist"; echo " |Tracklist"; } echo "
"; echo "
"; echo ""; echo ""; echo "