jentino28
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
mysql date search
in MySQL Help
Posted
I looked around and googled but can't find a straight answer.
I designed a website where i have my links as :
Today | Yesterday | Past 5 days | Past 7 days | Past month
i can do "today" and "yesterday" mixing php's time functions and mysql but im struggling with "7 days".
i attempted using DATE_SUB(CURDATE(),INTERVAL 7 DAY); but it only pulls queries found on the last 7th day, not between now and seven days.which is what im looking for.
Please help me.
thanks. ;)