Logo Sensation Rock

Les concerts par salle

[vc_row][vc_column width=”2/3″][vc_column_text][insert_php] include (“/home/sensationrock/connexion.php”);
mysql_query(“SET NAMES ‘utf8′”);
$salle = mysql_real_escape_string($_GET[‘salle’]);
if ($salle==”){
$salle=”Agenda concert – Salles”;
}
echo ““.$salle.”“;

[/insert_php]

LES CONCERTS PAR SALLES


Trier les concerts par date, ville ou par salle

[insert_php] include (“/home/sensationrock/connexion.php”);
mysql_query(“SET NAMES ‘utf8′”);
$salle = mysql_real_escape_string($_GET[‘salle’]);
if ($salle!=”){
$req=”SELECT s.*,a.*,v.* FROM wp_gigpress_shows s,wp_gigpress_artists a, wp_gigpress_venues v WHERE v.venue_name='”.$salle.”‘ AND 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”;
}
else {
$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 v.venue_city,s.show_venue_id,s.show_date asc”;
}
$res=mysql_query($req);
$ville_tempo=”;
while ($voir=mysql_fetch_array($res)){
if ($salle_tempo!=$voir[‘venue_name’]){
echo “

“.$voir[‘venue_name’].” (“.$voir[‘venue_city’].”)

“;
$salle_tempo=$voir[‘venue_name’];
}
$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[‘artist_name’].” “.$voir[‘show_notes’].”“;
if ($salle){echo ” – “.$salle.”
“;}else{echo ”
“;}

}

[/insert_php][/vc_column_text][/vc_column][vc_column width=”1/3″][vc_widget_sidebar sidebar_id=”single”][/vc_column][/vc_row]