title: time not being recorded in mysql database
body: <p>I am attempting to record a time (hours:mins:secs) chosen by the user via <code>select</code> form. The other data posted via the form is entered correctly in the database but the "start time" is being recorded as <code>0000-00-00 00:00:00</code>.</p>
  
  <p>User selects the start time here:</p>
  
  <pre><code>&lt;p &gt;Start time (24hrs):
  &lt;span class="right"&gt;
  Hour:
  &lt;select name="event-start-time-hours" class="event-time"&gt;
      &lt;option value="01"&gt;01&lt;/option&gt;
      &lt;option value="02"&gt;02&lt;/option&gt;
      &lt;option value="03"&gt;03&lt;/option&gt;
      &lt;option value="04"&gt;04&lt;/option&gt;
      &lt;option value="05"&gt;05&lt;/option&gt;
      &lt;option value="06"&gt;06&lt;/option&gt;
      &lt;option value="07"&gt;07&lt;/option&gt;
      &lt;option value="08" selected&gt;08&lt;/option&gt;
      &lt;option value="09"&gt;09&lt;/option&gt;
      &lt;option value="10"&gt;10&lt;/option&gt;
      &lt;option value="11"&gt;11&lt;/option&gt;
      &lt;option value="12"&gt;12&lt;/option&gt;
      &lt;option value="13"&gt;13&lt;/option&gt;
      &lt;option value="14"&gt;14&lt;/option&gt;
      &lt;option value="15"&gt;15&lt;/option&gt;
      &lt;option value="16"&gt;16&lt;/option&gt;
      &lt;option value="17"&gt;17&lt;/option&gt;
      &lt;option value="18"&gt;18&lt;/option&gt;
      &lt;option value="19"&gt;19&lt;/option&gt;
      &lt;option value="20"&gt;20&lt;/option&gt;
      &lt;option value="21"&gt;21&lt;/option&gt;
      &lt;option value="22"&gt;22&lt;/option&gt;
      &lt;option value="23"&gt;23&lt;/option&gt;
      &lt;option value="24"&gt;24&lt;/option&gt;
  &lt;/select&gt;
      Min:
  &lt;select name="event-start-time-mins" class="event-time"&gt;
      &lt;option value="00" selected &gt;00&lt;/option&gt;
      &lt;option value="05"&gt;05&lt;/option&gt;
      &lt;option value="10"&gt;10&lt;/option&gt;
      &lt;option value="15"&gt;15&lt;/option&gt;
      &lt;option value="20"&gt;20&lt;/option&gt;
      &lt;option value="25"&gt;25&lt;/option&gt;
      &lt;option value="30"&gt;30&lt;/option&gt;
      &lt;option value="35"&gt;35&lt;/option&gt;
      &lt;option value="40"&gt;40&lt;/option&gt;
      &lt;option value="45"&gt;45&lt;/option&gt;
      &lt;option value="50"&gt;50&lt;/option&gt;
      &lt;option value="55"&gt;55&lt;/option&gt;
  &lt;/select&gt;
  </code></pre>
  
  <p>and is recorded via:</p>
  
  <pre><code>$event = new event($_POST, $dbh);
  // Record Event to database
  $event-&gt;setEvent();
  </code></pre>
  
  <p>I format the start time in the setevent() method like so:</p>
  
  <pre><code>// format start time
  $stime = mktime($_POST['event-start-time-hours'], $_POST['event-start-time-mins'], 0);
  $eventStartTime = date("H:i:s", $stime);
  </code></pre>
  
  <p>and bind the variable like os:</p>
  
  <pre><code>$stmt-&gt;bindParam(11, $eventStartTime);
  </code></pre>
  
  <p>Which correlates to the correct column in the table.</p>
  
  <p>So why is it not recorded in the <code>datetime</code> field?</p>