NOW() in mysql query

Discussion in 'PHP' started by Silver89, Mar 8, 2008.

0
  1. #1
    Hi,

    I'm trying to perform this query to select users where their active date is within the last 10 minutes however i'm not sure if this is how to do it,

    
mysql_query("SELECT username,id FROM user WHERE activeDate > 'NOW()-00:10:00'");
    PHP:
     
    Silver89, Mar 8, 2008 IP