title: comparing date and time php
body: <p>i need to compare two dates where if one date is greater than the other then an sql will run. this is my code</p>
  
  <pre><code>date_default_timezone_set('Asia/Kuala_Lumpur');
  $date = date('Y-m-d G:i:s');
  $query = mysql_query("SELECT * FROM package_transaction");
  if(mysql_num_rows($query) &gt; 0) {
      while($row = mysql_fetch_array($query)) {           
          $transac_code = $row['transac_code'];
          $duedate = $row['payment_due'];
  
          if(strtotime($date) &gt; strtotime($duedate))
          {
              mysql_query("UPDATE package_transaction SET `status` = 'cancelled' WHERE `payment_due` = `$duedate` AND `transac_code` = `$transac_code`");
  
          }
  
      }
  }
  </code></pre>
  
  <p>but its not working. please help</p>