title: MySQL php INSERT INTO ... SELECT: use commas to join $var+value
body: <p>I need to use this php query:</p>
  
  <pre><code>INSERT INTO table1(id,picture) SELECT id, $var.picture from table2
  </code></pre>
  
  <p>Where $var is "<a href="http://example.com/images/" rel="nofollow">http://example.com/images/</a>".</p>
  
  <p>Example (before):</p>
  
  <pre><code>ID = 1
  picture = 'flower.jpg'
  </code></pre>
  
  <hr>
  
  <p>Example (after):</p>
  
  <pre><code>ID = 1
  picture = 'http://example.com/images/flower.jpg'
  </code></pre>
  
  <p>How can I join in the SELECT $var and picture (the commas not working)...</p>