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. Link to comment https://forums.phpfreaks.com/topic/278169-mysql-updating-a-list-and-displaying/ 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 Link to comment https://forums.phpfreaks.com/topic/278169-mysql-updating-a-list-and-displaying/#findComment-1430981 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. Link to comment https://forums.phpfreaks.com/topic/278169-mysql-updating-a-list-and-displaying/#findComment-1430983 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.