Doing a Query based on Date - HELP needed!!

**tahoo** · Oct 6, 2001 18:44

I would like to get some help with a query that I can't seem to figure out.

I have this table with a DATE-column. The query should only select those rows that covers the last 5 days and save it into e.g. $result

I bet it's quite easy to do...so please someone help me a.s.a.p. :-)

Thx in advance!

/tahoo

**Paul S** · Oct 6, 2001 18:57

You need to

1) to order descendingly your rows by date
2) Select the first 5 rows,

here's the query

Code:

SELECT DATACOLUM as result FROM tablename ORDER BY columndate DESC LIMIT 5;

**DR_LaRRY_PEpPeR** · Oct 6, 2001 20:00

it sounds like he wants stuff from the last 5 days, not the 5 most recent things. if so, this should do that:

Code:

SELECT whatever FROM table WHERE date_col >= DATE_SUB(NOW(), INTERVAL 5 DAYS) ORDER BY date_col DESC

**tahoo** · Oct 7, 2001 08:25

Yes...you're right Dr LarryPepper! :-)

That was what I wanted to do - and it worked just fine! (when I removed the "S" from "DAYS" that you wrote :-))

Thanks!

One last thing on this issue...I would like to print the result in opposite direction. As it is now the results comes out with the post made 5 days ago on top. I would like to go the other way with the latest post on top.

Do you have a suggestion? Or maybe someone else can help me?