Transparent

Transparent
\n"; echo "\n"; echo "\n"; $limit = $_GET['limit']; if (!isset($limit)) { $set_limit = " LIMIT 25"; } else { $set_limit = ""; // Add view $sql_add_view = "UPDATE site_stats SET count = count + 1 WHERE st_stts_id = '3'"; $result_add_view = mysql_query($sql_add_view); } $sql_series = "SELECT *, UNIX_TIMESTAMP(time) as time FROM photo_series ORDER BY time DESC $set_limit"; $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"; if (!isset($limit)) { echo "\n"; echo "\n"; echo "\n"; } } echo "\n"; echo "\n"; echo "\n"; ?>
\n"; echo "Transparent
\n"; echo " " . $serie_day . " " . $serie_month . " " . $serie_year . " - " . $row_series["serie"] . "

\n"; echo " (" . $photos_in_serie . " photos)\n"; echo "
\n"; echo "Transparent
\n"; echo "
\n"; echo "Transparent
\n"; echo "
\n"; echo "Transparent
\n"; echo " Other photos (without a serie)\n"; echo "
\n"; echo "Transparent
\n"; echo "
\n"; echo "Transparent
\n"; echo "
\n"; echo "
 > View all series


\n"; echo "
\n"; echo "
\n"; echo "