player

LES CONCERTS PAR VILLES :  




Trier les concerts par date, ville ou par salle

[insert_php]
if ($_POST[‘villes’]){
$req=”SELECT s.*,a.*,v.* FROM sensationrock.wp_gigpress_shows s,sensationrock.wp_gigpress_artists a, sensationrock.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’).”‘ AND v.venue_city='”.$_POST[‘villes’].”‘ ORDER BY v.venue_city,s.show_date,v.venue_name asc”;
}
else {
$req=”SELECT s.*,a.*,v.* FROM sensationrock.wp_gigpress_shows s,sensationrock.wp_gigpress_artists a, sensationrock.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 v.venue_city,s.show_date,v.venue_name asc”;
}
$res=mysql_query($req);
$ville_tempo=”;
while ($voir=mysql_fetch_array($res)){
if ($ville_tempo!=$voir[‘venue_city’]){
echo ”

“;
echo “

“.$voir[‘venue_city’].”

“;
$ville_tempo=$voir[‘venue_city’];
}
$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;
}

echo ““.$voir[‘venue_name’].” : “.$voir[‘artist_name’].” “.$voir[‘show_notes’].”
“;

}

[/insert_php]

Disques
GLIZ, CYDALIMA

Cinq ans après leurs débuts et une poignée de EP convaincants, les Jurassiens de Gliz…