title: Trying to post date via php with mySQL... Need help
body: <p>I'm trying to post the date and time at the time I create a new record.  The record is created but the 'add_time' column is blank in mySQL.</p>
  
  <p>What's wrong with it?</p>
  
  <pre><code>$date = date("Y-m-d G:i:s") ; 
  
  $order = "INSERT INTO cartons_added (add_time, type, part_no, add_type, add_qty, 
  add_ref, add_by, add_notes)
  
  VALUES
  ('$_POST[date]',
   '$_POST[type]', 
   '$_POST[part_no]', 
   '$_POST[add_type]', 
   '$_POST[add_qty]', 
   '$_POST[add_ref]', 
   '$_POST[add_by]', 
   '$_POST[add_notes]')";
  
   $result = mysql_query($order);
  </code></pre>