title: Can't update mysql database with text
body: <p>I can update my database using the following code:</p>
  
  <pre><code>$id = 1;
  $client = 3456;
  $sql = "UPDATE production SET client=$client WHERE id=$id";
  </code></pre>
  
  <p>However, if the <code>$client</code> variable is a text string (instead of numeric), it won't work.</p>
  
  <pre><code>$id = 1;
  $client = "some text";
  $sql = "UPDATE production SET client=$client WHERE id=$id";
  </code></pre>
  
  <p>The client field in my database is VARCHAR with a limit of 50 characters. Is there anything obvious I'm overlooking?</p>