1 2 3 4 5 6 7 8 9 10 11 12 13 14
| $sqlQuery =
" SELECT ETABLISSEMENT_TYPE_URL, ETABLISSEMENT_ID, ETABLISSEMENT_URL_NAME, SOIREE_FRANCE_BILLET, SOIREE_FRANCE_BILLET_URL, EVENEMENT_SOUS_TYPE_LABEL, EVENEMENT_TYPE_URL, EVENEMENT_TYPE_URL, SOIREE_ID , EVENEMENT_TYPE_LABEL , SOIREE_TITLE , SOIREE_DESCRIPTION , DATE_FORMAT(SOIREE_DATE, '%d-%m-%Y') AS DATE , SOIREE_DATE_FIN , SOIREE_LIEU , SOIREE_PRIX , SOIREE_HEURE , SOIREE_URL_TITLE" .
" FROM SOIREE ".
" INNER JOIN EVENEMENT_TYPE ON EVENEMENT_TYPE.EVENEMENT_TYPE_ID = SOIREE_TYPE ".
" LEFT JOIN EVENEMENT_SOUS_TYPE ON SOIREE_SOUS_TYPE=EVENEMENT_SOUS_TYPE_ID".
" LEFT JOIN ETABLISSEMENT ON SOIREE_LIEU_ID=ETABLISSEMENT_ID".
" LEFT JOIN ETABLISSEMENT_TYPE ON ETABLISSEMENT_TYPE_ID=ETABLISSEMENT_TYPEID".
" WHERE ( SOIREE_SECTEUR = '$idSecteur' AND SOIREE_DATE BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 180 DAY) )".
" OR ( SOIREE_SECTEUR = '$idSecteur' AND DATE(mktime(0,0,0,$nbrTodayYear,$nbrTodayMonth,$nbrTodayDay)) )".
" ORDER BY SOIREE_DATE ASC ";
$req = mysql_query($sqlQuery);
checkSqlError($sqlQuery);
$nbreligne = mysql_num_rows($req);
while($data = mysql_fetch_array ($req)) { |
Partager