title: php mysql adodb
body: <p>I'm using PHP with adodb but come up against a massive problem. I'm using adodb to speed up development so I can do thing like:</p>
  
  <pre><code>$r["Name"] = $_POST['txtName'];
  
  if ($_POST["ID"] != "")
    $conn-&gt;AutoExecute("content", $r, 'UPDATE', 'AutoID = ' . $_POST["ID"]);      
  else
    $conn-&gt;AutoExecute("content", $r, 'INSERT');
  </code></pre>
  
  <p>However if that name was to have a single quote in it saves into db with a slash! So if the name is Testimonial's it will save as Testimonial\'s which is causing me massive problems, is there anyway I can avoid this but still program like above as it's hell of a lot quicker than preparing insert / update statements.</p>
  
  <p>Cheers</p>