execRequete("SELECT partydat FROM parties WHERE id=".$party.""); $party_date=mysql_fetch_assoc($date_result); preg_match("/([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})/i",$party_date['partydat'], $regs); $party_date=$regs[3].".".$regs[2].".".$regs[1]; $liste=$bd->execRequete("SELECT partydat, artists.id AS artistid, artistname, artistcountry, artistradio, artisten, artisturl, artistcat, hour, hourto, permalink FROM artists, relartistsparties, parties WHERE parties.id=".$_GET['party']." AND idp = parties.id AND ida = artists.id ORDER BY idp, relartistsparties.rank"); //$j=0; echo "

Line Up for ".$party_date."

"; echo "Click the name to read more / hear mixes or tracks"; //echo "

".translate("clickartistname")."

"; while ($list=$bd->ligneSuivante($liste)) { echo "

".$list['artistname']." - ".$list['artistcountry']."
"; echo $list['hour']." - ".$list['hourto']." - "; echo $list['artistcat']; //show text or not if ($_GET['id']==$list['artistid']) { echo "

"; } else { echo "
"; //show artist text in lg eval('echo "

".$list["artist'.$lg.'"]."

";'); //show direct link echo "

http://www.fingerspitzengefuhl.be/artist/".$list['permalink'].""; //show website if ($list['artisturl'] != '') echo "

website"; //show flash if ($list['artistradio'] != '') echo "

".$list['artistradio']; //show pictures of artist echo "

"; showxl ('artists','',$list['artistid']); echo "

"; } } echo "

> Listen to their music"; echo "

> Download their mixes (members only)"; echo "

> See all artists who played at Finger"; } ############### ## ARTIST ID ## ############### elseif (!empty($artist)) { $liste=$bd->execRequete("SELECT * FROM artists WHERE id=".$_GET['artist']); while ($list=$bd->ligneSuivante($liste)) { echo "

".$list['artistname']." (".$list['artistcountry'].") - ".$list['artistcat']."

"; //show artist text in lg eval('echo "

".$list["artist'.$lg.'"]."

";'); //show website if ($list['artisturl'] != '') echo "

website"; //show flash if ($list['artistradio'] != '') echo "

".$list['artistradio']; //show pictures of artist echo "

"; showxl ('artists','',$list['artistid']); } } ############### ## PERMALINK ## ############### elseif (!empty($artistperm)) { $liste=$bd->execRequete("SELECT * FROM artists WHERE permalink='".$_GET['artistperm']."'"); while ($list=$bd->ligneSuivante($liste)) { echo "

".$list['artistname']." (".$list['artistcountry'].") - ".$list['artistcat']; echo "

"; //show artist text in lg eval('echo "

".$list["artist'.$lg.'"]."

";'); //show direct link echo "

http://www.fingerspitzengefuhl.be/artist/".$list['permalink'].""; //show website if ($list['artisturl'] != '') echo "

artist website"; //show flash if ($list['artistradio'] != '') echo "

".$list['artistradio']; //show pictures of artist echo "

"; showartistxl ('artists','',$list['id']); } // show list of dates he-she played $lista=$bd->execRequete("SELECT partydat, artists.id AS artistid, parties.id AS partyid, ida, idp FROM artists, relartistsparties, parties WHERE permalink='".$_GET['artistperm']."' AND idp = parties.id AND ida = artists.id ORDER BY parties.id DESC"); echo "

Will be/was at following parties
Click for full line up

"; while ($listb=$bd->ligneSuivante($lista)) { $partyid = $listb['partyid']; $partydat = showdat($listb['partydat'],$lg); echo "".$partydat."
"; } } ################## ## WALK OF FAME ## ################## else { // put text of text table //eval('$showtexte=$texte["text'.$lg.'"];'); // on repère les illustrations dans le texte, et on les affiche avec le lien pour afficher le grand format à droite //$result=PutPict($showtexte,$texte['id']); //echo $result['txt']; echo "Every artist who has played at FingerSpitzenGefuhl

Click on the name to read, see and listen."; /* echo "

Click here to see the line up for the next party on 27/06/2009"; */ $liste=$bd->execRequete("SELECT * FROM artists WHERE walkoffame_finger = 'y' ORDER BY artistname"); while ($list=$bd->ligneSuivante($liste)) { echo "

"; /*if ($list['artistradio']!='') { echo " "; }*/ //echo "".$list['artistname']." (".$list['artistcountry'].") - ".$list['artistcat']; echo "".$list['artistname']." (".$list['artistcountry'].") - ".$list['artistcat']; echo "

"; //show text or not if ($_GET['id']==$list['id']) { echo "
"; } else { echo "
"; //show artist text in lg eval('echo "

".$list["artist'.$lg.'"]."

";'); //show website if ($list['artisturl'] != '') { echo "

website"; } //show flash if ($list['artistradio'] != '') { echo "

".$list['artistradio']; } //show pictures of artist echo "

"; showxl ('artists','',$list['id']); echo "

"; } } } ?>