title: PHP MySQL Date Comparsion
body: <p>I Have a Mysql with the rows Data1,data2,data3...Data7 and i want to compare with the current date,searching the internet i got this so far:</p>
  
  <pre><code>$curDate = date("Y-m-d");
  $query = "SELECT Id FROM Programacao where Data1 = $curDate";
  $result = mysql_query($query);   
  if(!$result) {echo 'Nada';}
  while ($row = mysql_fetch_array($result))
  {
       echo "Id = ".$row ['Id'];
  }
  </code></pre>
  
  <p>But i can read only the first one,does it possible to compare all of them at the same time?</p>