title: Update query error on 1 field SQLSTATE[42000]
body: <p>I keep getting this error:</p>
  
  <blockquote>
    <p>SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
    error in your SQL syntax; check the manual that corresponds to your
    MySQL server version for the right syntax to use near 'show = '1'
    WHERE ( owner  =  1  AND  id  =  63 )' at line 1</p>
  </blockquote>
  
  <p>My query keeps crashing on column <code>show</code>, I can't figure out why.</p>
  
  <p>This is how I am trying to update this column:</p>
  
  <pre><code>$show = (escape(Input::get('showcontact')) == '') ? 0 : 1;
  
  $property-&gt;update(array(
                                  'propertytype' =&gt; escape(Input::get('type')),
                                  'address' =&gt; escape(Input::get('address')),
                                  'postalcode' =&gt; escape(Input::get('postal')),
                                  'sqf' =&gt; escape(Input::get('sqf')),
                                  'price' =&gt; escape(Input::get('price')),
                                  'deposit' =&gt; escape(Input::get('deposit')),
                                  'description' =&gt; escape(Input::get('description')),
                                  'listed' =&gt; escape(Input::get('list')),
                                  'email' =&gt; escape(Input::get('email')),
                                  'show' =&gt; $show,
                                  'phone' =&gt; escape(Input::get('phone'))
                              ));
  </code></pre>
  
  <p>Column show is of type <code>smallint</code>. I can insert fine, I just can't update that column. If I comment out the <code>show</code>, my update query works fine.</p>
  
  <p>I am really confused by this.</p>