title: convert input date to mysql readable format
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/5920225/php-mysql-format-date-time">PHP/MySQL - Format date/time</a>  </p>
  </blockquote>
  
  
  
  <p>I have input field (name:day1 and varchar) to enter date in my form. It attached with a jquery calendar and picks the date in the format "D, dd M, yy" (I WANT TO PICK LIKE THIS AND CANT CHANGE FORMAT). I want to convert and save into mysql date format into table. How is this possible?</p>
  
  <pre><code>$insert_query = 'insert into '.$this-&gt;tablename.'(
              venue,
              day1,
              day2,
              day3,
              day4,
              day5,
              day6,
              day7,
              day8,
              day9,
              day10,
              city,
              contactperson,
              )
              values
              (
              "' . $this-&gt;SanitizeForSQL($formvars['venue']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day1']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day2']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day3']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day4']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day5']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day6']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day7']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day8']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day9']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['day10']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['city']) . '",
              "' . $this-&gt;SanitizeForSQL($formvars['contactperson']) . '",
              )';
  </code></pre>
  
  <p>day 1 to day 10 are the dates want to convert...</p>