ElePHPant Haven

Just pointing out this article that could totally be me. If I was female and stupid enough to leave Larry alone in a car.

And on an unrelated note, I've made a blog archive widget thingy. It uses some funky SQL like

$sql = "SELECT MONTH(`ArticlePage`.`Date`) AS `Month`, count(`ArticlePage`.`ID`) AS `Articles` FROM `ArticlePage`, `SiteTree` WHERE `SiteTree`.`ID` = `ArticlePage`.`ID` AND YEAR(`ArticlePage`.`Date`) = '{$this->Year}' AND `SiteTree`.`ParentID` IN (SELECT `ID` FROM `ArticleHolder` WHERE `ShowInArchive` = true) GROUP BY MONTH(`ArticlePage`.`Date`) ORDER BY MONTH(`ArticlePage`.`Date`) DESC";

Mmm, tasty.