Re: update query based on array

not real sure of the setup of the form but if you have mutiple groups of items to be updated then you should make the rank an array -- rank[pid#] you should make all the items -- that are related part of the same group -- by using [] On Mon, 2002-12-09 at 15:06, Jason Dulberg wrote: > I am displaying a list of data (from an sql query) and some of the fields in > that list are editable through a form. If the user chooses to edit one or > more of the rows of data, they must click on a checkbox to add that row to > an "update array". The problem is that when I read that array to pass to an > UPDATE sql statement, it only passes the last entry of the array. > > Here's an example of the data being passed: > 13 - 4 - UPDATE ranking SET category='Prep School', rank='30' WHERE pid=4 > 14 - 169 - UPDATE ranking SET category='Prep School', rank='30' WHERE > pid=169 > 15 - 166 - UPDATE ranking SET category='Prep School', rank='30' WHERE > pid=166 > > The above is created based on the following html code: > //the last row > <input type="text" name="category" value="Prep School"> > <input type="text" name="rank" value=30 size=4> > <input type="checkbox" name="rankid[15]" value="166"> > > So as you can see, its only reading the last row and assigning its values to > the data above as well. > > Here's what I'm using for the sql query: > > while(list($key,$val)=each($rankid)) { > $upd=mysql_query("UPDATE ranking SET category='$category', > rank='$rank' > WHERE pid=$val"); > } > > If anyone has any suggestions for fixing this problem, please let me know :) > THanks > > > __________________ > Jason Dulberg > Extreme MTB > http://extreme.nas.net -- Jimmy Brake <jimmy@isurge.com>