How to insert concatenated values into single column?
<p>i am writing an application that queries data from different tables and concatenates them together before it inserts them into angle          table.I am running into a few challenges,and will need some help.Below is some of my code:           </p>

<pre><code>       $sql="select employees.id as  id,message_dispensary,message_surgery,message_biochemistry,heading 
               from messages
              join supervisors
                  using(employee_id)
               join employees
              on (employees.id=supervisors.employee_id)";   
             $result=mysqli_query($link,$sql) or die ("error in retrieving results.".mysqli_error($link));  
      while ($row=mysqli_fetch_assoc($result))
    {
        echo "&lt;tr&gt;&lt;td&gt;&lt;input type='text' name='message[]' value=".$row['heading'].'&amp;nbsp;'.$row['message_surgery'].'&amp;nbsp;'.$row  ['message_biochemistry'].'&amp;nbsp;'";?&gt;
       "&lt;/td&gt;&lt;/tr&gt;";
    }
        ?&gt;
       &lt;tr&gt;&lt;td&gt;&lt;input type="submit"&gt; &lt;/form&gt; &lt;/table&gt;      
</code></pre>

<p>my problem is how to get "ALL" the values i am placing in the input box named "messages"...the values keep truncating, and some rows do not have some of the values. Please show me where i am missing it or even a more elegant solution.Thanks.... </p>
