12) { $m2 -= 12; $y2++; } $dt2 =$y2."-".$m2."-1"; $dt2hi=$y2."-".$m2."-31"; $result = mysql_query ("SELECT * FROM `blog` WHERE TO_DAYS(`date`) >= TO_DAYS('$dt2') and TO_DAYS(`date`) <= TO_DAYS('$dt2hi');"); if ($result && mysql_num_rows($result) > 0) { echo "".$mo[$m2]." ".$y2."\n"; return 1; } return 0; } $mo[1]='January'; $mo[2]='February'; $mo[3]='March'; $mo[4]='April'; $mo[5]='May'; $mo[6]='June'; $mo[7]='July'; $mo[8]='August'; $mo[9]='September'; $mo[10]='October'; $mo[11]='November'; $mo[12]='December'; include 'stats.inc'; include '../mysql.inc'; mysql_connect (localhost, $username, $password); mysql_select_db ($dbuse); // get month/year if ($dt == '') { $dt = getdate(); $m = $dt['mon']; $y = $dt['year']; } else // extract month and year { $dd = split('-',$dt); $y = $dd[0]; $m = $dd[1]; } $datelow = $y.'-'.$m.'-01'; $datehi = $y.'-'.$m.'-31'; $time1 = mktime(0, 0, 0, $m, 1, $y); $dt1 = getdate($time1); ?>
Archives for


= TO_DAYS('$datelow') and TO_DAYS(`date`) <= TO_DAYS('$datehi') ORDER by `date` ASC;"); $day = mysql_fetch_array($result); // prime it if ($result && $day) { echo ""; $offset = $dt1['wday']; $dy = 1 - $offset; for ($row = 1; $row < 7; $row++) { echo ""; for ($col = 1; $col < 8; $col++) { echo "\n"; } echo "\n"; } echo "
"; $_date = $y.'-'.($m<10?"0":"").$m.'-'.($dy<10?"0":"").$dy; if ($day['date'] == $_date) { $thumb = $day['thumb']; if ($thumb == '') { $thumb = 'x'; } // display it $link1 = ""; echo ""; echo "
".$link1."\"".$day['title'].":\n"; echo "
".$link1.$dy."
\n"; // get next record $day = mysql_fetch_array($result); } $dy++; echo "
\n"; } else { echo "What can I say ... no pictures this month.

\n"; } // prev months if (link_month($m-2, $y)) echo "       \n"; if (link_month($m-1, $y)) echo "       \n"; echo "| | | |      \n"; // next months if (link_month($m+1, $y)) echo "       \n"; if (link_month($m+2, $y)) echo "               \n"; incrementVisits ("photoblog_archive_".$m."-".$y,$REMOTE_ADDR,0,$_SERVER['HTTP_REFERER']); mysql_close(); ?>