end_here; $query = "SELECT DATE_FORMAT(w.weblog,'%M %e, %Y'),w.title, w.category, c.name, w.myid, DATE_FORMAT(weblog,'%Y%m%d'), w.subcategory, DATE_FORMAT(weblog,'%Y'), Year(w.weblog) as year FROM weblog w, dailycategory c where w.category=7 and w.category = c.myid and Year(w.weblog) > 2013 and w.weblog <= CURDATE() order by w.myid DESC"; $result = mysql_query($query) or die("Query failed : " . mysql_error()); while ($line = mysql_fetch_array($result, MYSQL_NUM)) { $bgcolor = "white"; $category=$line[2]; $year=$line[7]; $rows[$year] .= "$line[0]$line[1]"; } mysql_free_result($result); mysql_close($link); foreach ($rows as $x => $x_value) { $content .= <<

$x New Engalnd Blog Postings

$x_value
DateTitle
end_here; } $localcss = <<SetParameter("MetaDescription","cryan blog"); $page->SetParameter("MetaDescription", "Latest Blog on cryan.com"); $page->SetParameter("MetaKeyword", "Interesting New England Places"); $page->SetParameter("sidecontent", $sidecontent); $page->SetParameter("localcss", $localcss); $page->SetParameter("headertitle", "Blog Homepage"); $page->SetParameter("content", $content); $page->SetParameter("leftnav", $showmenu); $page->SetParameter("blog", $showblog); $page->SetParameter("update", $update); $page->SetParameter("specialmenu", $specialmenu); $page->SetParameter("conversion", $conversion); $page->CreatePage(); ?>