Select all where last 7 days from variable

[liamloveslearning]

Hi all, im trying to select all values from a database for x user where the date is from the last 7 days, im trying this query to no avail, could anybody please take a look?

 

SELECT *
FROM model_pictures
WHERE user_id = colname AND model_pictures.user_picture_date > DATE_sub(model_pictures.user_picture_date, interval 7 DAY) 

[liamloveslearning]

In fact, I need a to make an if statement which says if user x has a record containing the upload date between today and the last 7 days, dont show form, To do this im triying to make a query which calls that data and my query is the above, Does this make sense?

[liamloveslearning]

this seems to be working but its days in the future not SUB days?

 

SELECT *
FROM model_pictures
WHERE user_id = colname AND model_pictures.user_picture_date > DATE_SUB(CURDATE(), INTERVAL 7 DAY)

[liamloveslearning]

Ive just realised i need <= as opposed to equals too but it still doesnt seem to work?

[waterssaz]

Use BETWEEN curdate and the date_sub even

[liamloveslearning]

so...

 

SELECT *
FROM model_pictures
WHERE user_id = colname AND BETWEEN curdate() AND model_pictures.user_picture_date (DAY(CURDATE()), interval 7 day)

[liamloveslearning]

sorted!

 

SELECT *

FROM model_pictures

WHERE user_id = colname AND model_pictures.user_picture_date BETWEEN DATE_SUB(CURDATE(), INTERVAL 7 DAY) AND CURDATE()

[waterssaz]

no like

 

SELECT *FROM model_picturesWHERE user_id = colname AND model_pictures.user_picture_date BETWEEN  BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 7 DAY ) AND CURDATE( ) 

 

 

[waterssaz]

beat me lol :-) But mine had extra BETWEEN typo as well