1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| $requete1 = "SELECT DISTINCT `email`, `date` FROM `base`
WHERE date like '$date%'
ORDER BY `ident` DESC";
$resa = mysql_query($requete1, $db) or mysql_die(mysql_error($db));
$nbr = mysql_num_rows($resa);
while ($compte = mysql_fetch_object($resa)) {
$d_email[] = $compte->email;}
for ($i = 0; $i < $nbr; $i++) {
echo "'$d_email[$i]',";
}
$requete2 = "SELECT COUNT(email) AS nbr_doublon, email FROM `dossier` WHERE email IN ('".$d_email[$i]."') GROUP BY email
HAVING COUNT(email) > 1";
}
echo "'') GROUP BY email
HAVING COUNT(email) > 1"; |
Partager