1 2 3 4 5 6 7 8 9 10
|
$select = "SELECT count(id) FROM gestion_assur_prevoyance WHERE valid_contrat='En cours' AND DATE_FORMAT(date_effet, '%m-%d') > DATE_FORMAT(NOW(), '%m-%d') AND DATE_FORMAT(date_effet, '%m-%d') < DATE_FORMAT(NOW() + INTERVAL 60 DAY, '%m-%d')";
$result = mysql_query($select,$db) or die ('Erreur : '.mysql_error() );
$row = mysql_fetch_row($result);
$total = $row[0];
$select = "SELECT * FROM gestion_assur_prevoyance WHERE valid_contrat='En cours' AND DATE_FORMAT(date_effet, '%m-%d') > DATE_FORMAT(NOW(), '%m-%d') AND DATE_FORMAT(date_effet, '%m-%d') < DATE_FORMAT(NOW() + INTERVAL 60 DAY, '%m-%d') ORDER BY DATE_FORMAT(date_effet, '%m-%d') ASC limit $limite,$nombre"; |
Partager