1 2 3 4 5
| (...)
// Requetes SQL
$sql = $connexion->query ("SELECT * FROM $table");
$select = $connexion->query ("SELECT *, TO_DAYS( NOW( ) ) - TO_DAYS( `Saisie` ) > 15 AS last, TO_DAYS( NOW( ) ) - TO_DAYS( `Date` ) > 15 AS new, TO_DAYS( NOW( ) ) - TO_DAYS( `Date` ) > 30 AS hava, TO_DAYS( NOW( ) ) - TO_DAYS( `Date` ) > 60 AS med, TO_DAYS( NOW( ) ) - TO_DAYS( `Date` ) > 90 AS old, TO_DAYS( NOW( ) ) - TO_DAYS( `Date` ) > 120 AS megaold, TO_DAYS( NOW( ) ) - TO_DAYS( `DatRel` ) < 15 AS datrelnew, TO_DAYS( NOW( ) ) - TO_DAYS( `DatRel2` ) < 15 AS datrelnew2, TO_DAYS( NOW( ) ) - TO_DAYS( `DatTrans` ) < 15 AS dattransnew FROM $table WHERE `Actif` <> 'Non' ORDER BY Date ASC");
(...) |
Partager