title: Placing variables in php update query
body: <p>Ok I know this is a simple question, I've been trying for hours now though.</p>
  
  <p>I have four variables: </p>
  
  <pre><code>$id
  $name
  $part
  $source
  </code></pre>
  
  <p>I am trying to place them into a query for updating my database like so: </p>
  
  <pre><code>mysqli_query($con,"UPDATE members SET name='".$name."', part='".$part."' WHERE id='1'");
  </code></pre>
  
  <p>For some reason the WHERE isn't highlighted in red for my code editor like it should be (like UPDATE and SET are.)</p>
  
  <p>How can I place these variables into the string without ending the string early?</p>
  
  <p>I know it's an easy fix I just can't figure it out :(</p>
  
  <p>Based on comments, I now have: </p>
  
  <pre><code>mysqli_query($con,"UPDATE members SET name=".$name.", part=".$part." WHERE id=".$id."");
  </code></pre>