[Resolved] limit db out-put by date

[mehrzadsoft]

i wanna limit my database out put by date. for example how can i show query searched in 3 last days (each days record is not fixed).

please help me.

[mrhappiness]

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

WHERE post_date >= NOW() - INTERVAL 3 DAY

hth

[mehrzadsoft]

thanks my friend mrhappiness for your answers. and for your hints about MARKING MY QUESTION alot, I found this useful froum soon and its a long way to know how to use this stuff correctly, but am sure with your hints i will learn as soon as i could.

thanks for anything😉