\n"; echo "

Groupes

\n"; $sql = "SELECT ioa.artists.*,pochettemin FROM ioa.artists LEFT join ioa.albums_last ON artist_name=artist WHERE ioa = '1' ORDER BY artist_name ASC"; $db=pg_query($sql); while ($ligne = pg_fetch_object ($db)) { //$tmpadresse=str_replace(" ","20","$ligne->name");//marche pas artistligne_imagette($ligne); echo "
"; } echo "
\n

Groupes historiques / en sommeil / RIP / plus a l'asso...

\n"; $sql = "SELECT ioa.artists.*,pochettemin FROM ioa.artists LEFT join ioa.albums_last ON artist_name=artist WHERE ioa = '2' ORDER BY artist_name ASC"; $db=pg_query($sql); while ($ligne = pg_fetch_object ($db)) { //$tmpadresse=str_replace(" ","20","$ligne->name");//marche pas artistligne_imagette($ligne); } echo "
\n

Mais aussi...

\n"; $sql = "SELECT * FROM ioa.artist_link WHERE ioa = '3' ORDER BY artist_name ASC"; $db=pg_query($sql); echo "\n"; echo "

Ils ont joué avec nous : (et on les en remercie)

"; $sql = "SELECT DISTINCT artist_link.* FROM ioa.artist_link INNER JOIN (ioa.concertartist INNER JOIN ioa.concerts ON ioa.concertartist.concert = ioa.concerts.concert ) ON artist_link.artist_name = concertartist.artist WHERE asso LIKE '%Ici Ou Ailleurs%' AND ioa = '0' ORDER BY artist_name ASC "; $db=pg_query($sql); echo "\n"; echo "
\n\n"; } else { $sql = "SELECT DISTINCT ioa.artists.* FROM ioa.artists WHERE artist_name='".$artist."';"; $db=pg_query($sql); $ligne = pg_fetch_object ($db); $nbmp3=$ligne->nbmp3; $nbvideos=$ligne->nbvideos; $nbphotos=$ligne->nbphotos; echo "
\n"; echo "

"; echo $artist."

\n"; echo ""; liens_externe_artist($artist); echo "\n"; //echo "$ligne->sousstyle\n"; echo "
\n"; concert_a_venir_artist($artist); if ($nbmp3>0) { echo "

Derniers album /démo

\n"; dernier_album_artist_mobile($artist); anciens_album_artist($artist); } compils_artist($artist); if ($nbvideos>0) { echo "\n

Videos

\n"; $sql = "SELECT * FROM ioa.videos_main WHERE artist LIKE '".addslashes($artist)."' AND full_path LIKE '%youtube%' "; $result = pg_query($sql) or die('Query failed: ' . pg_error()); while($ligne = pg_fetch_object($result)) { video_mobile($ligne); } videos_artist($artist); echo "
"; } //videos_artist_borderline($artist); troisd_live_video_vignettes("WHERE artist='".addslashes($artist)."'"); if ($nbphotos>0) { echo "\n

Photos

\n"; $sql_photos="WITH tmp_photos as (SELECT max(note) as meilleure_note FROM ioa.photos_main WHERE artist='".addslashes($artist)."') SELECT * FROM tmp_photos NATURAL JOIN ioa.photos_main WHERE note=meilleure_note AND artist='".addslashes($artist)."' ORDER BY datesite DESC LIMIT 15;"; $sql="SELECT * FROM ioa.photos_main WHERE artist='".addslashes($artist)."' LIMIT 12"; affiche_photos_diapo($sql_photos); // affiche_photos($sql_photos); echo "
"; } $sql = "SELECT ioa.artists.*,pochettemin FROM ioa.artists LEFT join ioa.albums_last ON artist_name=artist WHERE artist_name IN (SELECT DISTINCT artist_name FROM ioa.zicos_artist WHERE artist_name<>'".$artist."' AND id_zicos IN (SELECT id_zicos FROM ioa.zicos_artist WHERE artist_name='".$artist."') ) ORDER BY artist_name ASC"; $db=pg_query($sql); if (pg_num_rows($db)) { echo "\n

Featuring members or ex-members of :

\n"; while ($ligne = pg_fetch_object ($db)) { artistligne_imagette($ligne); } echo "
"; } past_shows($artist); echo "
\n"; // div sub_artist } echo "";//content include "footer.php"; ?>