title: MySql datetime field in HTML/php table is only showing date when using form
body: <p>I have a <code>datetime</code> MySql field named <code>down_stamp</code> that I have populating an HTML table via php:</p>
  
  <pre><code>&lt;? $sql_el = "SELECT * FROM events WHERE loc_id = '$lid'";
  $result_el = mysql_query($sql_el);
  while ($row_el = mysql_fetch_array($result_el)) {
  ?&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;?=$row_el['down_stamp']?&gt;&lt;/td&gt;
  &lt;/tr&gt;
  &lt;/form&gt;
  &lt;? } ?&gt;
  </code></pre>
  
  <p>This produces results in the format I'd like: <code>2013-09-15 08:30:00</code>. However, I'd like to make this field modifiable, so if I just convert it into a form element like this:</p>
  
  <pre><code>&lt;form name="fm_editevent" method="post"&gt;
  &lt;tr&gt;
    &lt;td&gt;&lt;input name="down_stamp_ed" required="required" value=&lt;? echo $row_el['down_stamp']; ?&gt; type="text"&gt;&lt;/td&gt;
    &lt;td&gt;&lt;input value="Update" type="submit" name="update_el"&gt;&lt;/td&gt;     
  &lt;/tr&gt;
  &lt;/form&gt;
  &lt;? } ?&gt;
  </code></pre>
  
  <p>Then the <code>down_stamp</code> field only displays the date: <code>2013-09-15</code>. I don't think it's a width issue as there's plenty of room in the text box. I tried adding <code>&lt;td width=100&gt;</code> (twas a guess). I also tried to declare the time in php when expanding the variable, which just gave me an error and the date <code>1970-01-01 01:33:33</code></p>
  
  <pre><code>&lt;td&gt;&lt;input name="down_stamp_ed" required="required" value=&lt;? echo date("Y-m-d H:i:s", $row_el['down_stamp']);?&gt; &gt;&lt;/td&gt;
  </code></pre>
  
  <p>How can I get the full datetime field data to echo in this form text box?</p>