GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Tech Display SQL record from today and past 30 days?

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.

.

11-14-2022, 09:14 PM
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!