How to insert concatenated values into single column?
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:           
 

           $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 "<tr><td><input type='text' name='message[]' value=".$row['heading'].'&nbsp;'.$row['message_surgery'].'&nbsp;'.$row  ['message_biochemistry'].'&nbsp;'";?>
           "</td></tr>";
        }
            ?>
           <tr><td><input type="submit"> </form> </table>      
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.... 


How to insert concatenated values into single column?
===

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:           
 

           $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 "<tr><td><input type='text' name='message[]' value=".$row['heading'].'&nbsp;'.$row['message_surgery'].'&nbsp;'.$row  ['message_biochemistry'].'&nbsp;'";?>
           "</td></tr>";
        }
            ?>
           <tr><td><input type="submit"> </form> </table>      
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.... 

