|
|
"; } ?>
5 and actif_infos_news = 1 order by id_infos_news DESC LIMIT 0,".$custom5;
$drn_infoReq=mysql_query($drn_infoSQL);
while ($valdrn_info = mysql_fetch_array($drn_infoReq)) {
?>
|
:
|
set_date_EN(SUBSTR($valdrn_info["date_msl_infos_news"],0,10));
echo $d->date_Fr();?>
|
 |
|
|
= debut_promo_bplan)) AND ";
}
else {
$addpromo = "";
}
if ($ville!="") {
$ville=STR_REPLACE("%20", " ",$ville);
if ($ville=="idf") {
$addville = " ( pays = 'france' AND ((LEFT(bplan.cp,2)='75') OR (LEFT(bplan.cp,2)='91') OR (LEFT(bplan.cp,2)='92') OR (LEFT(bplan.cp,2)='93') OR (LEFT(bplan.cp,2)='94') OR (LEFT(bplan.cp,2)='95') OR (LEFT(bplan.cp,2)='77') OR (LEFT(bplan.cp,2)='78')) ) AND ";
$addpromo = " (((id_categ = 5 or id_categ = 6) AND dates <= DATE_ADD(CURRENT_DATE,INTERVAL 7 DAY)) or (promo_bplan = 1 AND CURRENT_TIMESTAMP >= debut_promo_bplan)) AND ";
}
else {
$addville = " ( pays = '".$pays."' AND ville = '" .$ville. "') AND ";
$addpromo = "";
}
}
$drn_bplan_zoukSQL = "select * from bplan where ".$addville." ".$addpromo." id_categ <> 10 AND dates >= DATE_SUB(CURRENT_TIMESTAMP,INTERVAL 6 HOUR) AND dates <= DATE_ADD(CURRENT_DATE,INTERVAL ".$intervalpromo." DAY) order by YEAR(dates), DAYOFYEAR(dates), id_categ desc, promo_bplan desc, stat_bplan desc LIMIT 0,200";
//echo $drn_bplan_zoukSQL;
}
else {
$drn_bplan_zoukSQL = "select * from bplan where (((id_categ = 5 or id_categ = 6) AND dates <= DATE_ADD(CURRENT_DATE,INTERVAL 7 DAY)) or (promo_bplan = 1 AND CURRENT_TIMESTAMP >= debut_promo_bplan)) and id_categ <> 10 AND dates >= DATE_SUB(CURRENT_TIMESTAMP,INTERVAL 6 HOUR) AND dates <= DATE_ADD(CURRENT_DATE,INTERVAL 7 DAY) order by YEAR(dates), DAYOFYEAR(dates), id_categ desc, promo_bplan desc, stat_bplan desc LIMIT 0,200";
}
$drn_bplan_zoukReq=mysql_query($drn_bplan_zoukSQL);
//'Requette dernier bon plan (prochain zouk)
while ($valdrn_zks_bplan = mysql_fetch_array($drn_bplan_zoukReq)) {
$eve=$eve+1;
$ndt1=SUBSTR($valdrn_zks_bplan["dates"],0,10);
if ($ndt1 != $ndt2) {?>
set_date_EN($ndt1);
$d->afficher_date_lettre();
$ndt2=$ndt1;?>
|
|
= CURRENT_DATE and month(dates) >= ". $mon ." AND year(dates) >= ". $year ." ORDER BY dates ASC";
//$rslt_sortirQL2 = "select distinct dates from bplan";
$rslt_bonplanReq2 = mysql_query( $rslt_sortirQL2 );
// loop through all the days of the month
while ( $d <= $lastday) {
///while (($valbonplanReq2 == mysql_fetch_array($rslt_bonplanReq2)) && $try1 != substr($valbonplanReq2["dates"],8,2) ) {
///try1=substr($valbonplanReq2["dates"],8,2);
///}
// set up blank days for first week
if ($firstweek) {
echo "";
for ($i=1; $i<=$firstwday; $i++) {
echo "| | ";
}
$firstweek = false;
}
if ($wday==0) {
// Sunday start week with
echo " ";
}
// print cell
//
echo "| $d | ";
if ($wday==6) {
// Saturday end week with
echo "\n";
}
$wday++;
$wday = $wday % 7;
$d++;
///loop;
}
?>
ALBUM :
|
|
INFO 
" width="110" height="72" hspace="4" vspace="2" border="1" align="left">
" width="110" height="40" border="1" align="left">
" width="100" height="100" vspace="3" border="1">