Display SQL record from today and past 30 days?
 

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

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.

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.

.

https://stackoverflow.com

You're welcome.

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?

GFY is faster :1orglaugh

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