Mailing overzicht

\n"; echo " \n"; if ($row["nie_dOpg"]>0) { $datum = createDateFormat($row["nie_dOpg"]); echo " \n"; } else { echo " \n"; } if ($row["nie_dVer"]>0) { $datum = createDateFormat($row["nie_dVer"]); echo " \n"; } else { echo " \n"; } if ($row["nie_dVer"]>0) { echo ""; } else { echo " \n"; } if ($row["nie_dVer"]>0) { echo " "; } else { echo " \n"; } echo " \n"; } ?>
Archief
Nieuwsbrief Opgemaakt Verzonden Ontvangen Locatie
" .$row["con_tNam"] ."" .$datum["day"] ."-" .$datum["month"] ."-" .$datum["year"] ." om " .$datum["hour"] .":" .$datum["minute"] ." -" .$datum["day"] ."-" .$datum["month"] ."-" .$datum["year"] ." om " .$datum["hour"] .":" .$datum["minute"] ." -"; $resulttmp = database("SELECT count(*) as totaal FROM `mailing` where mai_iNie=" .$row["nie_iNie"]); while($rowtmp = mysql_fetch_array($resulttmp)) { $totaal = $rowtmp["totaal"]; } $resulttmp = database("SELECT (100/" .$totaal .")*count(*) as percent FROM `mailing` where mai_iNie=" .$row["nie_iNie"] ." and mai_dOnt =0"); while($rowtmp = mysql_fetch_array($resulttmp)) { echo round($rowtmp["percent"],1) ."% heeft de afbeeldingen niet opgehaald.
"; } $resulttmp = database("select left(mai_dOnt,8)*1000000 as datum, (100/" .$totaal .")*count(*) as percent, count(*) from `mailing` where mai_dOnt>0 and mai_iNie=" .$row["nie_iNie"] ." group by left(mai_dOnt,8) order by mai_dOnt limit 7"); while($rowtmp = mysql_fetch_array($resulttmp)) { $datum = createDateFormat($rowtmp["datum"]); echo round($rowtmp["percent"],1) ."% heeft de mail gelezen op " .$datum["day"] ."-" .$datum["month"] ."-" .$datum["year"] ."
"; } echo "
-Google Maps /\n"; echo "Google Earth -