Today will take a look back at Year of 2011 in photos. Next week, I plan on doing an article featuring the Best of Photos of 2011. UNIX_TIMESTAMP(‘2011-1-1’) AND `date` < UNIX_TIMESTAMP('2012-1-1') ORDER BY `date` ASC"; $query = mysql_query("$sql"); while ($series = mysql_fetch_assoc($query) ) { $date = strtotime($series['dated']); if ($prevdate != date('F', $date) ) { echo '

‘.date(‘F Y’, $date).’.

‘;
$min = strtotime( date(‘F 1, Y’, $date) );
$max = strtotime( date(‘F t, Y’, $date).’ 11:59 AM’);

$sql = “SELECT `phototypes`.`filename` AS ‘type’, `photos`.`filename` FROM `photos`,`phototypes` WHERE `photos`.`typeid` = `phototypes`.`id` AND `date` > $min AND `date` < $max AND `phototypes`.`filename` NOT LIKE 'maps%' ORDER BY rand() LIMIT 1"; $pquery = mysql_query("$sql"); $photo = mysql_fetch_assoc($pquery); echo "

\n\n

“;

}

echo “{$series[‘title’]} / “.date(‘F j, Y’, $date).”
“;

$prevdate = date(‘F’, $date);

}

?>