player

LES CONCERTS PAR DATES

Trier les concerts par date, ville ou par salle

[insert_php]
include (“/home/sensationrock/connexion.php”);
mysql_query(“SET NAMES ‘utf8′”);
$req=”SELECT s.*,a.*,v.* FROM wp_gigpress_shows s,wp_gigpress_artists a, wp_gigpress_venues v WHERE a.artist_id=s.show_artist_id AND v.venue_id=s.show_venue_id AND show_expire>='”.date(‘Y-m-d’).”‘ ORDER BY s.show_date,v.venue_city,v.venue_name asc”;
$res=mysql_query($req);
while ($voir=mysql_fetch_array($res)){
$date = date(“d-m-Y”, strtotime($voir[‘show_date’]));
if ($voir[‘show_multi’]==1){
$date .= ” au “.date(“d-m-Y”, strtotime($voir[‘show_expire’]));
}
if ($date_tempo!=$date){
echo “

“.$date.”

“;
$date_tempo=$date;
$ville_tempo=”;
}
if ($ville_tempo!=$voir[‘venue_city’]){
echo $voir[‘venue_city’].”, “;
$ville_tempo=$voir[‘venue_city’];
}
echo ““.$voir[‘venue_name’].” : “.$voir[‘artist_name’].” “.$voir[‘show_notes’].”
“;

}

[/insert_php]

Disques
BROKEN SOCIAL SCENE, Let’s Try The After Vol.1 Vol.2

Deux après Hug Of Thunder publié chez Arts & Crafts en 2017, les canadiens de…