title: INSERT $_POST values into MySQL table if some are empty
body: <p>I have (in short) code like this:</p>
  
  <pre><code>...
  mysql_query("INSERT INTO table1 (x,y,z) VALUES (".$_POST['a'].",".$_POST['b'].",\"".$_POST['c']."\")");
  ...
  </code></pre>
  
  <p><code>a</code> is numeric value, <code>b</code> is numeric but empty in form and <code>c</code> is string value, which can be empty(there is no problem).</p>
  
  <p>Tthen for MySQL it looks like this:</p>
  
  <pre><code>INSERT INTO table1 (x,y,z) VALUES (2,,"");
  </code></pre>
  
  <p>Problem is part of values, where is nothing like in <code>b</code>. Is there any solution to get it work? In database settings, or in PHP. I have big table and it is not possible to check every <code>$_POST</code> value.</p>
  
  <p>thanks</p>