title: Extracting only date from datetime field (mysql) and assigning it to php variable
body: <p>I am unable to assign only date to a php variable from <code>datetime</code> field of a MySQL table. I am using <strong>PHP 4</strong>, I know how to do it in PHP 5.</p>
  
  <p>Can someone help as to what is missing from the below php code.</p>
  
  <pre><code>$dc = mysql_query("SELECT * FROM INVHDR WHERE Invdate BETWEEN '2011-04-01' AND '2012-03-31'");
  while ($dc2 = mysql_fetch_assoc($dc)) {
      $invno      = $dc2['Invno']; // Here Invno is a datetime field type
      $invdat3    = $dc2['Invdate'];
      $date_array = explode("-", $invdat3);
      $invdat     = sprintf('%02d/%02d/%4d', $date_array[2], $date_array[1], $date_array[0]);
  }
  </code></pre>