title: Comparing current date/time with date/time in a database
body: <p>I need to create something to display an image based on the current date and time.  I have an SQL table set up that looks like this:</p>
  
  <pre><code>eventid | startdate  | enddate    | imgfile    | status
  6       | 2013-04-29 | 2013-05-03 | finals.jpg | active
  </code></pre>
  
  <p>What I need to do is compare the start date and end date to the current date, and if the current date falls within the startdate and enddate, then display the imgfile.</p>
  
  <p>I'm not sure how to go about this, but this is what I tried.</p>
  
  <pre><code>//get current date and time
  $currentdatetime = strtotime(now);
  $formatteddatetime = date("y-m-d", $currentdatetime);
  
  while($row=mysql_fetch_array($getimage))
  {
      //get variable for startdate
      $formattedstartdate = date("y-m-d", $row[startdate]);
      $formattedenddate = date("y-m-d", $row[enddate]);
      if($formatteddatetime &gt;= $formattedstartdate AND $formatteddatetime &lt;= $formattedenddate AND $row[status] == 'active')
      {
          echo $row[imgfile];
      }
  }
  ?&gt;
  </code></pre>
  
  <p>Right now, it doesn't show anything inside of the entire while statement.  Am I at least on the right track?</p>