to_days(DATE_SUB(now(), INTERVAL 1 DAY))"; } elseif ($timeframe == "week") { $where_date = "to_days(edit_time) > to_days(DATE_SUB(now(), INTERVAL 7 DAY))"; } elseif ($timeframe == "month") { $where_date = "to_days(edit_time) > to_days(DATE_SUB(now(), INTERVAL 1 MONTH))"; } elseif ($timeframe == "year") { $where_date = "to_days(edit_time) > to_days(DATE_SUB(now(), INTERVAL 1 YEAR))"; } $sql = "SELECT DISTINCT wiki_pages.pagename, date_format(wiki_versions.edit_time,'%a %D %M %Y') as edit_time, wiki_versions.user FROM wiki_versions, wiki_pages WHERE (($where_date) AND (wiki_pages.id = wiki_versions.id)) ORDER BY edit_time DESC"; $loc_db->query($sql); echo "[today] [past week][past month][past year]"; $end_of_table = 0; $loc_db->next_record(); while ($end_of_table == 0) { $current_time = $loc_db->f("edit_time"); echo "

" . $current_time . "

"; echo ""; while ($current_time == $loc_db->f("edit_time")) { $page = rawurlencode($loc_db->f("pagename")); echo "
  • " . $loc_db->f("pagename") . " (diff) ...... " . $loc_db->f("user") . "
    "; if (!$loc_db->next_record()) $end_of_table = 1; } echo "
  • "; } ?>