include("inc/db.inc.php");
$division = "Home";
// WitzKategorien auslesen
$query_kategorie = "SELECT kategorie_id, kategorie_wert from kategorie";
$result_kategorie = mysql_query($query_kategorie);
// Anzahl der Witze auslesen
$resultID = mysql_query("SELECT COUNT(witz_id) FROM witz where witz_online != 0");
$witz_total = mysql_result($resultID,0);
// Anzahl der Bilder auslesen
$resultID = mysql_query("SELECT COUNT(bild_id) FROM bild where bild_online != 0");
$bild_total = mysql_result($resultID,0);
// Anzahl der Newsletterabonnenten auslesen
$newsletterID = mysql_query("SELECT COUNT(nl_id) FROM nl where status = 1");
$newsletter_total = mysql_result($newsletterID,0);
// Zufallswitz auslesen
$query_zufallswitze = "SELECT witz_text FROM witz ORDER BY RAND() LIMIT 1";
$result_zufallswitze = mysql_query($query_zufallswitze);
if ($absenden == "true") {
if (($email != "") && (strstr($email,"@")) && (strstr($email,"."))) {
header("Location: http://www.spass-team.de/newsletter_work.php?email=$email&action=$action");
} else {
$fehler = "Bitte geben Sie Ihre E-Mail ein.
";
}
}
echo "";
?>