Multiple data items into one field of SQL

[da_mic_1530]

Probably the wrong / badly phrased question

Anyhoo

I wish for the submission of a text box to be placed into a SQL field (submissions) along with all the existing submissions

Ala

existing submissions
Test1
Test2
Test3

Add New submission Test4


And how via PHP would I pull them back out again and display them

It's going to be a PHP insert statement, but won't that just override/error message the existing data?

Point me in the right direction and I'll leave you all alone I do try honestly, learnt so much from this forum

 

[daz]

Grab what's there, concatenate, re-insert?

 

[suarve]

concatenate what you've just added to the original contents of the text box and then do an insert?

EDIT: i type too slow.

 

[da_mic_1530]

Grab what's there, concatenate, re-insert?

sorry to bring this back, but although I understand exactly what your saying I am unable to find a tutorial to help me on my way

E.g

Database called test, field called sub

Grab whats there from database test, field sub

Make it into a text string

Grab the new submission and make that into a text string

Add the 2 together, re-insert statement into database test, field sub

I understand but cannot fathom the code

**Asking kindly for help**