Zepo. Posted December 21, 2007 Share Posted December 21, 2007 I have a loop that outputs inputs, for setting. Right now i have it where you can only update one at a time. I want it to where you can update all of them at once. Example $sett = mysql_query("SELECT * FROM configuration"); while ($set = mysql_fetch_array($sett)){ echo"<form method='post'> <tr valign='top'> <td class='optiontitle' colspan='2'><div align='center'>$set[name]</div></td> </tr> <tbody id='tbody_keywords'> <tr valign='top'> <td class='alt1'><div class='smallfont' align='center'> <input type='text' name='set[value]' value='$set[value]' size='70' maxlength='40'> <input type='hidden' name='act' value='updateset'> <input type='hidden' name='set[name]' value='$set[name]'> <input type='image' src='./images/edit.png' name='submit'> </div> </td> </tr></form> "; } Quote Link to comment https://forums.phpfreaks.com/topic/82737-loop-updating/ Share on other sites More sharing options...
phpSensei Posted December 21, 2007 Share Posted December 21, 2007 What? For every column you have to have a different UPDATE query. Quote Link to comment https://forums.phpfreaks.com/topic/82737-loop-updating/#findComment-420816 Share on other sites More sharing options...
Zepo. Posted December 21, 2007 Author Share Posted December 21, 2007 But the thing is, how would i loop the data, then update all of the looped data? Quote Link to comment https://forums.phpfreaks.com/topic/82737-loop-updating/#findComment-420828 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.