title: Php mysql query update after 1 day
body: <p>Actually i am stuck in logic. </p>
  
  <p>i want after 1 day my query automatic update my ron 0 to 1 (is_new)</p>
  
  <pre><code>$timezone = "Asia/Karachi";
  if(function_exists('date_default_timezone_set')) date_default_timezone_set($timezone);
  $unixtime =  strtotime("-1440 minutes",strtotime($row['post_date']));
  echo $time = date(" d ",$unixtime);
  </code></pre>
  
  <p>so my table row is_new value will change 0 to 1</p>
  
  <p>P.S: what i want.
  Ans: i want when some thing add in database is show (New) and after 1 day new automatic will remove. ref : <a href="http://i43.tinypic.com/2iv1x0g.png" rel="nofollow">http://i43.tinypic.com/2iv1x0g.png</a></p>