echo "\n";
echo " | \n";
echo " \n";
echo "\n";
echo " Last 6 series\n";
echo "(> View all series)
\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 " " . $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";
}
while ($row_series = mysql_fetch_array($result_series));
}
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";
echo " Last 6 photos\n";
echo "(> View last 50 photos)\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 " " . $photo_day . " " . $photo_month . " " . $photo_year . " - " . $photo_hour . ":" . $photo_minute . "
\n";
echo " | \n";
echo "\n";
echo " \n";
echo " \n";
echo " \n";
echo " | \n";
echo " \n";
}
while ($row_photo = mysql_fetch_array($result_photo));
}
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 "\n";
echo "\n";
echo " \n";
echo " | \n";
echo " \n";
?>
|