title: Separating comma broken words in PHP and selecting extra information
body: <p>I've been trying to look into this for a while now but can't find an answer that explains the coding properly.  Basically I have a mysql table with 'connections' relevant to a user.  These connections are separated with a comma:</p>
  
  <p>connection1, connection2, connection3, connection4, etc</p>
  
  <p>What I need to do is to separate each one into an array like so:</p>
  
  <pre><code>$connection1
  $connection2
  $connection3
  $connection4
  </code></pre>
  
  <p>Then for each of these I need to be able to select sertain information from a different table, so for example:</p>
  
  <pre><code>(SELECT name,id FROM users WHERE username = (all of the connections above))
  </code></pre>
  
  <p>Could any of you let me kow how this would be possible? Thank you</p>