Tech Display SQL record from today and past 30 days? - GoFuckYourself.com

Publisher Bucks · 11-14-2022, 08:25 PM

I have this code, which lets me pull records from the 'created' column for todays date & time:

Quote:

SELECT * FROM table WHERE created >= CURRENT_TIMESTAMP;

What I'd like to do is have it pull records from the last 30 +/- days AND todays date, could anyone point me in the right direction as to how to make this happen?

Just to complicate it a little, Id like it to pull based on the month, so whether a recipe was added last year, 10 years ago, etc it'll still display the data as described below.

Basically, I'm wanting a pseudo page on my recipe site that gives visitors a list of 30 recipes for breakfast, lunch and dinner (that are recent additions) which will change every day, cycling through the last 90 recipe additions (per category)s, sort of like how the old POTD pages used to work.

TIA for any help.

sarettah · 11-14-2022, 09:14 PM

select * from table
where created >=DATE_SUB(current_date(), INTERVAL 30 DAY)
order by created desc

That will stack all records created in the past 30 days in descending order so that the newest records are at the top of the pile.

.

Tube Ace · 11-14-2022, 09:17 PM

https://stackoverflow.com

You're welcome.

Publisher Bucks · 11-14-2022, 10:11 PM

Quote:

Originally Posted by sarettah

select * from table
where created >=DATE_SUB(current_date(), INTERVAL 30 DAY)
order by created desc

That will stack all records created in the past 30 days in descending order so that the newest records are at the top of the pile.

.

Much appreciated sir

I assume if I wanted to add a longer date I just change the '30'? Like, INTERVAL 30 DAY isnt a set parameter in php?

Klen · 11-15-2022, 07:44 AM

Quote:

Originally Posted by Tube Ace

https://stackoverflow.com

You're welcome.

GFY is faster

Publisher Bucks · 11-15-2022, 04:16 PM

Quote:

Originally Posted by Klen

GFY is faster

With a lot less 'fluff' and arguing thrown in too

11-14-2022, 09:14 PM	#2
sarettah see you later, I'm gone Industry Role: Join Date: Oct 2002 Posts: 14,058	select * from table where created >=DATE_SUB(current_date(), INTERVAL 30 DAY) order by created desc That will stack all records created in the past 30 days in descending order so that the newest records are at the top of the pile. . __________________ All cookies cleared!

11-14-2022, 09:17 PM	#3
Tube Ace So Fucking Banned Industry Role: Join Date: Nov 2008 Location: with your dream girl Posts: 4,941	https://stackoverflow.com You're welcome.