[Resolved] multi row update

[cmason22]

this is probably easy for veterans, but i'm having some trouble.

i have a table:

id | href | showorder

this table stores image hrefs and a 'showorder' property which controls their order of printing.

i'm building an administrative tool to control the showorder. the page prints a form with the photos and then builds a drop down list for each photo to select a number for the showorder. a count is performed on the result to set the correct number of choices in each of the drop downs (i.e. if there are 11 record, each dropdown list is number 1 thru 11).

im not sure how to process the values to do the multi-update. i think if i name all the dropdowns 'Order[]' then i'll have a nice array with all the values. seems that i also need a corresponding array with the IDs to to the UPDATE, because just having the new showorder values is useless without the IDs. at the moment i'm trying to build in a loop to build an array $IDs[] that i'll pass with the form.

maybe i'm going about it the wrong way. i hope i've given enough info to allow somebody to help me out.

Charlie

[kerodeon]

Would you like to give an example of what you've already tried, so that way we can see exactly what you're trying to do and how you want to do it.

you could create a loop similar to this (may have errors, but you'll get the idea) :

$countnumber = 0;

$db = mysql_connect("localhost", "root");
mysql_select_db("mydb",$db);

do {
$countnumber=$countnumber+1;

$$countnumber = mysql_query("SELECT * FROM employees WHERE id='$countnumber'",$db);

}

while (countnumber<=11)

Then, in your dropdown list, just use print $1;, print $2, etc.

Im not sure if this is what you want, but you may be able to use some of it.

[cmason22]

it ended up being pretty simple. inside the while() that was building the drop downs $Dropdown[] i also made $IDs[]. so i passed 2 "synched" arrays and then it was easy to loop a SQL statement to do the update.