Hi guys. Currently I have this code.

PHP Code:

$result = mysql_query("SELECT TIME FROM $db_table WHERE ID='".$name."'");
    while($row = mysql_fetch_array($result))
          { 
        if (NOW() > $row['TIME'] + 1 month) {}
        else {}
                 } 


However this is not working. Basically I want to know weather the timestamp (TIME) stored on the database is more than a month old.

OK now I have this which I think is close but still does not work correctly.

PHP Code:

$result = mysql_query("SELECT TIME FROM $db_table WHERE ID='".$name."'");
    while($row = mysql_fetch_array($result))
          { 
        if ( time() > $row['TIME'] + strtotime('+1 second')) {
            echo ('old');
        } else { echo ('newish');
        }} 


SOLVED

PHP Code:

$result = mysql_query("SELECT TIME FROM $db_table WHERE ID='".$name."'");
    while($row = mysql_fetch_array($result))
          { 
        if ($time - $row['TIME'] < (24*60*60*30)) {
            $update = no; 
            echo ('Too new to update');}
        } 


MUST BE UNIX TIME

Use your db abilities...
If your TIME field is a timestamp, then:

PHP Code:

$result = mysql_query("SELECT TIME FROM $db_table WHERE ID='$name' and TIME<now()-interval 1 hour");