1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

PHP Datetime

Discussion in 'PHP' started by Dehisce, Nov 23, 2008.

  1. #1
    In my mysql I have a datetime. How do I run a query on that to select entries from last 3 minutes?
     
    Dehisce, Nov 23, 2008 IP
  2. wmtips

    wmtips Well-Known Member

    Messages:
    598
    Likes Received:
    70
    Best Answers:
    1
    Trophy Points:
    150
    #2
    SQL:
    select * from table where datefield >= date_sub(NOW(),interval 3 minute)
    Code (markup):
     
    wmtips, Nov 23, 2008 IP