title: Output concated value from mysql query
body: <p>I am trying to output a concated value from my query but am having some issues.</p>
  
  <p>Here is my query:</p>
  
  <pre><code>    $result = mysql_query(
  "SELECT c.company, n.nid, n.createdOn, CONCAT_WS(' ',c2.fname,c2.lname), CONCAT_WS(' ',c3.fname,c3.lname), n.urgent, n.description 
   FROM notes n 
   INNER JOIN Positions p ON FIND_IN_SET(p.id, n.forDepts) &gt; 0
   LEFT JOIN companies c ON c.userid = n.clientId
   LEFT JOIN companies c2 ON c2.userid = n.createdBy
   LEFT JOIN companies c3 ON c3.userid = n.claimedBy
   GROUP BY n.nid
   LIMIT 0,100"
   );
  </code></pre>
  
  <p>My array is printing like so:</p>
  
  <pre><code>Array ( [0] =&gt; Honda of Kirkland [company] =&gt; Honda of Kirkland [1] =&gt; 1 [nid] =&gt; 1 [2] =&gt; 2009-09-28 21:33:15 [createdOn] =&gt; 2009-09-28 21:33:15 [3] =&gt; [CONCAT_WS(' ',c2.fname,c2.lname)] =&gt; [4] =&gt; [CONCAT_WS(' ',c3.fname,c3.lname)] =&gt; [5] =&gt; 0 [urgent] =&gt; 0 [6] =&gt; Milestones [description] =&gt; Milestones )
  </code></pre>
  
  <p>I am trying it like this, but it does not work:</p>
  
  <pre><code>while ($row = mysql_fetch_array($result)) {
  $created_by = $row[3];
  }
  </code></pre>