robbins Posted December 30, 2006 Share Posted December 30, 2006 I've set up a row in a mysql table, and its a text type.... what i want to do, is everytime my members complete something, a piece of text goes into that row... and its echo'd in their profile.how do i append whats in the row... without overwriting text already in there? please give me some code that can do this... thank you very much! Quote Link to comment https://forums.phpfreaks.com/topic/32297-php-sql-i-need-some-help-please/ Share on other sites More sharing options...
wildteen88 Posted December 30, 2006 Share Posted December 30, 2006 I dont think SQL has an append feature. You're going to have to get the text from the field, then append what the user did and then re-insert the text back in to the database. Quote Link to comment https://forums.phpfreaks.com/topic/32297-php-sql-i-need-some-help-please/#findComment-149912 Share on other sites More sharing options...
robbins Posted December 30, 2006 Author Share Posted December 30, 2006 no, like its not a text field value that enters it....when they get to a page, it has and update that inserts for example -PHP-1- into the field... and the field is a text type in the database.isn't there a way to keep whats in the field and then add the new text in there also, while the old text in there stays in there. Quote Link to comment https://forums.phpfreaks.com/topic/32297-php-sql-i-need-some-help-please/#findComment-149917 Share on other sites More sharing options...
robbins Posted December 30, 2006 Author Share Posted December 30, 2006 i guess this isn't possible :'( Quote Link to comment https://forums.phpfreaks.com/topic/32297-php-sql-i-need-some-help-please/#findComment-149929 Share on other sites More sharing options...
Kairu Posted December 30, 2006 Share Posted December 30, 2006 I'm not sure what your saying..... From your first post what wildteen88 said should work..... Unless you mean it's a check box? In which case you would just compare against it, and if it's true you take the old data out of the database, append the new data, and put it all back in overwriting the old data. Quote Link to comment https://forums.phpfreaks.com/topic/32297-php-sql-i-need-some-help-please/#findComment-149933 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.