title: Cant insert string with single quote into MySQL database
body: <p>Am trying to insert a string <em>"what is your favorite uncle's name</em> into a mysql database and am getting error message:</p>
  
  <blockquote>
    <p>There was an error submitting your request 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 'YOUR FAVORITE UNCLE'S NAME?, mobile_no = '+4479094484999', country ' at line 4"*</p>
  </blockquote>
  
  <p>my code is:</p>
  
  <pre><code> $sec_ques2 = mysql_real_escape_string($sec_ques);
   $insert = "INSERT INTO customers SET 
   acc_status = 'Inactive',
   acc_type = '{$acc_type}',
   sec_question = '{$sec_ques2}',
   mobile_no = '{$m_number}',
   country =    '{$country}',
   passkey = '{$passkey}',
   sec_ans= '{$answer}',
   home_address= '{$h_address}',
   gender = '{$gender}',
   first_name = '{$f_name}',
   last_name= '{$l_name}',
   emp_status = '{$emp_status}',
   marital_status = '{$m_status}',
   email_address = '{$email}'";
  </code></pre>