E-mail when a new serie is posted?\n"; echo " \n"; echo "Do you want to you receive an e-mail when a new serie is posted? In that case you can enter your e-mail address here: \n"; echo " \n"; echo " \n"; echo "\n"; echo "\n"; echo " \n"; echo "\n"; } elseif ($action == "Unsubscribe") { echo "Unsubscribe\n"; echo " \n"; echo "Enter your e-mail address here: \n"; echo " \n"; echo " \n"; echo "\n"; echo "\n"; echo " \n"; echo "\n"; } elseif ($action == "UnsubscribeSubmit") { $sql_email = "UPDATE mailing_list SET active = '0' WHERE email = '$email'"; $result_email = mysql_query($sql_email); echo "Your e-mail address has been removed."; } else { $sql_email = "INSERT INTO mailing_list (email, active, time) VALUES ('$email', '1', NOW())"; $result_email = mysql_query($sql_email); echo "Thanks! Your e-mail address has been added."; } ?>

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $sql_series = "SELECT *, UNIX_TIMESTAMP(time) as time FROM photo_series ORDER BY time DESC LIMIT 6"; $result_series = mysql_query($sql_series); if ($row_series = mysql_fetch_array($result_series)) { do { $serie_month = strftime("%B", $row_series["time"]); $serie_day = strftime("%e", $row_series["time"]); $serie_year = strftime("%Y", $row_series["time"]); $pht_thmbnl_id = $row_series["pht_thmbnl_id"]; $sql_thumbnail = "SELECT * FROM photo_thumbnail WHERE pht_thmbnl_id = $pht_thmbnl_id"; // echo $sql_thumbnail; $result_thumbnail = mysql_query($sql_thumbnail); $row_thumbnail = mysql_fetch_array($result_thumbnail); $pht_srs_id = $row_series["pht_srs_id"]; $sql_count_photos_in_serie = "SELECT COUNT(*) FROM photo WHERE pht_srs_id = $pht_srs_id"; $result_count_photos_in_serie = mysql_query($sql_count_photos_in_serie); $photos_in_serie = mysql_result($result_count_photos_in_serie,0,0); echo "\n"; echo "\n"; echo "\n"; echo "\n"; } while ($row_series = mysql_fetch_array($result_series)); } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; ?>  Last 6 series\n"; echo "(> View all series) \n"; echo " \n"; echo " \n"; echo " " . $serie_day . " " . $serie_month . " " . $serie_year . " - " . $row_series["serie"] . " \n"; echo " (" . $photos_in_serie . " photos)\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $sql_photo = "SELECT *, UNIX_TIMESTAMP(time) as time FROM photo ORDER BY time DESC LIMIT 6"; $result_photo = mysql_query($sql_photo); if ($row_photo = mysql_fetch_array($result_photo)) { do { $photo_month = strftime("%B", $row_photo["time"]); $photo_day = strftime("%e", $row_photo["time"]); $photo_year = strftime("%Y", $row_photo["time"]); $photo_hour = strftime("%H", $row_photo["time"]); $photo_minute = strftime("%M", $row_photo["time"]); $pht_id = $row_photo["pht_id"]; $sql_thumbnail = "SELECT * FROM photo_thumbnail WHERE pht_id = $pht_id "; // echo $sql_thumbnail; $result_thumbnail = mysql_query($sql_thumbnail); $row_thumbnail = mysql_fetch_array($result_thumbnail); echo "\n"; echo "\n"; echo "\n"; echo "\n"; } while ($row_photo = mysql_fetch_array($result_photo)); } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; ?>  Last 6 photos\n"; echo "(> View last 50 photos)\n"; echo " \n"; echo " \n"; echo " " . $photo_day . " " . $photo_month . " " . $photo_year . " - " . $photo_hour . ":" . $photo_minute . " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " > View best of \n"; echo " > View 50 most visited photos \n"; echo " > Search photos \n"; echo " \n"; echo " \n"; echo "