I want to only show the last 7 days of data. How?
$query = mysql_query("SELECT Date, Time, Keyword, Position, Testcode, IPaddress, Bot, Nixxieurl1 FROM logfile ORDER BY 'date' DESC, 'time' DESC");
WHERE date >= NOW() - INTERVAL 7 DAY
Worked a treat, thanks! 🙂
