Logo Sensation Rock

Agenda Dates

[vc_row][vc_column width=”2/3″][vc_column_text]

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] [/vc_column_text][/vc_column][vc_column width=”1/3″][vc_widget_sidebar sidebar_id=”single”][/vc_column][/vc_row]