All I want, is a simple query to get data from a table that has been modified in the last 7 days.
I have a field called 'modified' that has a time stamp 0000-00-00 00-00-00. It seems to me I want a way to check the timestamps and grab which ones are less than 7 days old.
So the query might look something like:
SELECT * FROM players WHERE modified > (SUBDATE(CURDATE(), INTERVAL '7' DAY)
But obviously I'm bumping around in the dark.