Jump to content


Photo

displaying records older then 20 days


  • Please log in to reply
1 reply to this topic

#1 khan kaka

khan kaka
  • Members
  • PipPipPip
  • Advanced Member
  • 40 posts
  • Locationaustralia

Posted 13 November 2005 - 09:56 PM

i am using dreamweaver 8 and php.

i want to make a recordset that displays records older then 20 days.

i cant work out how to filter the date field.


thanks in advance
khan kaka

#2 Cook

Cook
  • Members
  • PipPipPip
  • Advanced Member
  • 64 posts
  • LocationSingapore

Posted 14 November 2005 - 12:42 AM

SELECT * FROM `mytable` WHERE `mydatefield` > (NOW() - INTERVAL 20 DAY)

Cook




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users