https://www.webmaster-forums.net/crss/node/1037301 en https://www.webmaster-forums.net/serverside-scripting/updating-field-multiple-rows#comment-1214010 <p>No problem!</p> Wed, 24 Jan 2007 22:29:27 +0000 timjpriebe comment 1214010 at https://www.webmaster-forums.net https://www.webmaster-forums.net/serverside-scripting/updating-field-multiple-rows#comment-1213998 <p>Okay, great. Now I have it building the string until it looks like this:</p> <p>UPDATE profiles_individual SET approved = '1' WHERE ID IN ('id1','id2','id3',)</p> <p>It's giving an error because of that trailing comma, right? I'll see if I can figure out how to get rid of that...</p> <p>Update: done! That was easy <img src="https://www.webmaster-forums.net/misc/smileys/smile.png" title="Smiling" alt="Smiling" class="smiley-content" /> Thanks for the help!</p> Wed, 24 Jan 2007 16:54:00 +0000 Megan comment 1213998 at https://www.webmaster-forums.net https://www.webmaster-forums.net/serverside-scripting/updating-field-multiple-rows#comment-1213997 <p>Something more like this:</p> <p>UPDATE profiles_individual<br /> SET approved = '1'<br /> WHERE ID IN ('id1', 'id2', 'id3', 'id4')</p> Wed, 24 Jan 2007 16:37:59 +0000 timjpriebe comment 1213997 at https://www.webmaster-forums.net