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.
mysql date search
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users