Gayner Posted September 1, 2009 Share Posted September 1, 2009 What's different? anything better? Im editing a text and submit it thru get variable should i use Update or Insert? lol Link to comment https://forums.phpfreaks.com/topic/172639-updateinsert/ Share on other sites More sharing options...
ShaunO Posted September 1, 2009 Share Posted September 1, 2009 UPDATE is to update an already existing row(s) in a database table INSERT is to create a new row(s) in a database table Should be easy to figure out what you need based on what the two different functions actually do. Link to comment https://forums.phpfreaks.com/topic/172639-updateinsert/#findComment-909997 Share on other sites More sharing options...
Gayner Posted September 1, 2009 Author Share Posted September 1, 2009 UPDATE is to update an already existing row(s) in a database table INSERT is to create a new row(s) in a database table Should be easy to figure out what you need based on what the two different functions actually do. Oh ok sweet. i'll use update then, i aint making new tables lol thanks mysql_query("UPDATE ibf_members SET n = '{$Profile['n']}' WHERE id = '{$ibforums->member["id"]}'"); I want to edit more and update more then jsut the variable "N" possible? Link to comment https://forums.phpfreaks.com/topic/172639-updateinsert/#findComment-909998 Share on other sites More sharing options...
Philip Posted September 1, 2009 Share Posted September 1, 2009 Example: UPDATE table SET col1 = val1, col2 = val2, col3 = val3 WHERE id = 3 Link to comment https://forums.phpfreaks.com/topic/172639-updateinsert/#findComment-910003 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.