Get two weeks of data but group by a period of 7 days
SELECT 'last week' AS week, COUNT(*) AS rows 
    FROM table_name
    WHERE date_logged &gt;= CURDATE() - INTERVAL  6 DAY 
      AND date_logged  &lt; CURDATE() + INTERVAL  1 DAY
  UNION ALL
    SELECT 'previous week' AS week, COUNT(*) AS rows 
    FROM table_name 
    WHERE date_logged &gt;= CURDATE() - INTERVAL 13 DAY
      AND date_logged  &lt; CURDATE() - INTERVAL  6 DAY ;