title: Deleting a SQL entry after set amount of day (Set by the user)
body: <p>Hi we have a site that allows us to share passwords. The following used to delete the entry after a set number of days set by the user. This used to work but now no longer delete the entry. if it falls longer than the set number of days.</p>
  <pre><code>$sql=&quot;DELETE FROM database_name WHERE creation_date &lt; NOW() , INTERVAL days DAY&quot;;
  </code></pre>
  <p>Im not sure what could have gone wrong as when googling people are saying its correct.</p>
  <p>I have also tried the following</p>
  <pre><code> $sql=&quot;DELETE FROM database_name WHERE creation_date &lt; NOW() - INTERVAL days DAY&quot;;
  </code></pre>