name; ?> KOPPOP!

name."'"; $rListArtist = mysql_query($qListArtist); /* echo "lijst van allen met dezelfde naam:

"; while($listArtist = mysql_fetch_array($rListArtist)){ echo $listArtist['artistId']." - ".$listArtist['name']."
"; $qListBands = "select name from band, ab where band.bandId = ab.bandId and ab.artistId = '".$listArtist['artistId']."'"; $rListBands = mysql_query($qListBands); while($listBands = mysql_fetch_array($rListBands)){ echo "- ".$listBands['name']."
"; } } echo "

JE MOET NOG:

"; $qDuplicates = "SELECT name, COUNT(name) AS dup_count FROM artist GROUP BY name HAVING (COUNT(name) > 1)"; $rDuplicates = mysql_query($qDuplicates); while($duplicates = mysql_fetch_array($rDuplicates)){ echo $duplicates['name']." in ".$duplicates['dup_count']." bands.
"; } */ $qListBands = "Select name, ab.bandId From ab, band Where ab.artistId = '".$_GET['artistId']."' AND ab.bandId = band.bandId"; $rListBands = mysql_query($qListBands); ?>

Bands

Actief geweest in de volgende bands:

".$listBands['name']."
"; } ?>

Jaar: lastYear != "0"){ echo " - ".$artist->lastYear; } ?>
Plaats:

Bandleden

artistId.'" class="linkBold">'.$bandlid->name.' - '.$row['instrument'].'
'; } ?>

0){ ?>

Posters

'; } ?>

0){ ?>

Discografie

'; while($row = mysql_fetch_array($rPoster)){ if(strlen($row['thumb']) > 0){ $pic = ' '; }else{ $pic = ''; } echo ' '.$pic.'

'.$row['title'].'
Media: '.$row['media'].'
Label: '.$row['lable'].'
Jaar: '.$row['year'].'

'; } echo ''; ?>