title: single quotes in SQL Query
body: <p>Im writing a php script that is used to update a database but it is giving errors when i tries to run the query it returns an error along the lines of </p>
  
  <pre><code>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 'id=15"' at line 1
  </code></pre>
  
  <p>Where it says "To use near" seems to display part of the query after there is a space in the data. Im assuming i need to put single quotes around where the data to the query from the php variables but when i try to put them in (even escaping the quotes) i get parse errors from the script</p>
  
  <p>The SQL Query is </p>
  
  <pre><code>    mysql_query("UPDATE Videos SET Title=".$_POST['Title'].", Preacher=".$_POST['Preacher'].", Date=".$_POST['Date'].", Service=".$_POST['Service'].", File=".$_POST['File'].", Description=".$_POST['Description']."WHERE id=".$_GET['vid_id']."\"") or die(mysql_error());
  </code></pre>
  
  <p>Thank in advance for any help</p>