php - Mysql: results from last seven days

Question

It's my first time creating a website with PHP and MySQL. How do I query the results of a Mysql search to display only the results from the last 7 days?

The columns in my database are:

Id
Name
Date
Mensage

Answer 1

There's a few ways to do this. Here's one.

SELECT *
FROM tablename
WHERE `date` > CURRENT_DATE - INTERVAL 7 DAY

And another:

SELECT *
FROM tablename
WHERE DATEDIFF(`date`, CURRENT_DATE) < 7

FYI, you should not name your columns using reserved keywords. It's a bad idea and can only cause problems for you.