php - Get MySQL database entries within last week - Stack Overflow

PHOTO EMBED

Sun Jun 21 2020 13:31:54 GMT+0000 (Coordinated Universal Time)

Saved by @peota #mys #php

SELECT * FROM tableName WHERE timeColumn > UNIX_TIMESTAMP( date_sub(now(),interval 1 week)) and UserName = 'givenUserName'
content_copyCOPY

https://stackoverflow.com/questions/9632392/get-mysql-database-entries-within-last-week