$startdate = "2008-11-05"; ?>LO This Week – Archive
$lastweek = date("Y-m-d");
do {
$thisweek = date("Y-m-d", strtotime($lastweek . " -7days"));
$weekcount = array();
$query = "SELECT * FROM mem_chapters ORDER BY name";
$result = mysql_query($query) or die("Query failed: ($query) with error: " . mysql_error());
$num_results = mysql_num_rows($result);
for ($i = 0; $i < $num_results; $i++) {
$row = mysql_fetch_array($result);
$cquery = "SELECT contentID, title FROM wb_content WHERE (stamp < "" . $lastweek . "" AND stamp > “” . $thisweek . “”) AND title LIKE “%” . $row[“name”] . ” Chapter News%””;
$cresult = mysql_query($cquery) or die(“Query failed: ($cquery) with error: ” . mysql_error());
$crow = mysql_fetch_array($cresult);
if ($crow[“contentID”] > 0) {
$weekcount[] = $crow;
}
}
if (count($weekcount) > 0) {
?>Week of print(date("F j, Y", strtotime($thisweek))); ?>
-
foreach ($weekcount as $wrow) {
?>
- “> print(stripslashes($wrow["title"])); ?> } ?>
} $lastweek = $thisweek; } while (strtotime($lastweek) > strtotime($startdate));
?>