title: mysql date format, inserting a dash
body: <p>I'm trying to achieve this format <strong>01/01/2011 - 12:30pm</strong> for the date and time update into mysql how would I add in a dash and it my date format correct?</p>
  
  <pre><code>$sqlLD = "UPDATE ".$membtable." 
            SET m_lld= ".date("m/d/y g:i A")." 
            WHERE m_user='".$line['m_user']."'";
  
  $resultLD = @mysql_query($sqlLD); //insert format 01/01/2011 - 12:30pm
  </code></pre>
  
  <p><strong>Solve error on my part code wasn't updating to server. only a simple dash was needed.</strong></p>