DavidKing0r Posted May 19, 2013 Share Posted May 19, 2013 Hi, In my table I wish to have a list of items and have it updated via a form. From what I know I cannot just use UPDATE as it will overwrite whatever is in the field already. Example of what I would like to achieve. ID | Name | List 1 | One | blah.com, blah1.com, blah2.com 2 | Two | blah3.com, blah4.com, blah5.com How would I add more to the LIST without removing the ones already in it? And also how would I display it as a list 1, 2, 3.... etc. Cheers. Quote Link to comment Share on other sites More sharing options...
yomanny Posted May 19, 2013 Share Posted May 19, 2013 Hi, I think what you're looking for is CONCAT, read more about it here http://www.plus2net.com/sql_tutorial/concat.php Hope you work it out! - W Quote Link to comment Share on other sites More sharing options...
Jessica Posted May 19, 2013 Share Posted May 19, 2013 Google Data Normalizing - you're storing the data wrong. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.