title: How to update a field which have a blank space in it in PHP
body: <p>I have a field called "shop rate" in my Database. I want to update this field in PHP MySql.
  I am using Codeigniter update_string() function to update the field values.</p>
  
  <p>I have tried in two way but did not get any result..</p>
  
  <p>1st is the simple way that we use regularly..
  $posted["shop rate"] = $this->input->post('shop_rate');</p>
  
  <p>after this i get my Sql query like this
  UPDATE <code>table_name</code> SET <code>shop</code> rate = '545454' WHERE i_id = '190';</p>
  
  <p>2nd is, I have used backtick that is (``) (<code>shop rate</code>). but still it did not work.</p>
  
  <p>$posted[<code>shop rate</code>] = $this->input->post('shop_rate');
  and my sql query is
  UPDATE <code>table_name</code> SET <code>shop</code> rate` = '545454' WHERE i_id = '190';</p>
  
  <p>Thanks in advance</p>