1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| $sql2 = $db->prepare("SELECT count(*)
FROM activite
WHERE (
(`annee`=':anneedebut' AND
(`mois`>':moisdebut' OR
(`mois`=':moisdebut' AND `jour`>':jourdebut')
)
) OR
(`annee`=':anneefin' AND
(`mois`<':moisdebut' OR
(`mois`=':moisdebut' AND `jour`<':jourdebut')
)
)
)
AND `code_affaire`=':id'");
$sql2->execute(array(':anneedebut' => $_POST['annee'], ':moisdebut' => $_POST['mois'], ':jourdebut' => $_POST['jour'], ':anneefin' => $annee2, ':id' => $donnees['id'])) or die($sql2->errorInfo());
$donnees2 = $sql2->fetch(PDO::FETCH_ASSOC); |
Partager