Updating multipe rows with one form submit

[discostudio]

OK, here goes,

I have a reviews table and I need to edit multiple reviews at once, say all of them.

So how would I do this, I am currently doing the following:

<form method="post">
<table width="95%"  border="1" align="center" cellpadding="0" cellspacing="0" class="newstext">
 <tr bgcolor="#CCCCCC">
            <td height="20">Product Name </td>
            <td height="20"> Name</td>
            <td height="20"> Email </td>
            <td>Date</td>
            <td>Shop</td>
            <td>Validate</td>
            <td>Delete</td>

		</tr>
	  <?php 

   // start
   $sql34 = mysql_query("SELECT *,`products`.`prod_name` from `reviews` 
   INNER JOIN `products` on (review_product_id = product_id) 
   /*WHERE `active` = '1'*/ ORDER BY `review_date` desc;  ");
   while($RES2=mysql_fetch_array($sql34)) { ?>
	<tr>
            <td><?php echo stripslashes(trim(substr($RES2['prod_name'],0,30))); ?></td>
            <td><input name="review_name[<?php echo $RES2['rid']; ?>]" type="text" class="input" value="<?php echo stripslashes(trim($RES2['review_name'])); ?>"></td>
            <td><input name="review_email[<?php echo $RES2['rid']; ?>]" type="text" class="input" value="<?php echo stripslashes(trim($RES2['review_email'])); ?>"></td>
            <td><input name="review_date[<?php echo $RES2['rid']; ?>]" type="text" class="input" value="<?php echo $RES2['review_date']; ?>" size="15"></td>
            <td><input name="shop_id[<?php echo $RES2['rid']; ?>]" type="text" class="input" value="<?php echo $RES2['shop_id']; ?>" size="1"></td>
            <td><input name="active[<?php echo $RES2['rid']; ?>]" type="text" class="input" value="<?php echo $RES2['active']; ?>" size="1"></td>
            <td><input name="delete[<?php echo $RES2['rid']; ?>]" type="checkbox" value="delete"></td>
			</tr>
			<tr>
            <td colspan="7"><input name="review_title[<?php echo $RES2['rid']; ?>]" type="text" class="input" value="<?php echo stripslashes(trim($RES2['review_title'])); ?>" size="100"> 
              Location: 
                <input name="review_location[<?php echo $RES2['rid']; ?>]" type="text" class="input" value="<?php echo stripslashes(trim($RES2['review_location'])); ?>"></td>
            </tr>
			<tr>
            <td colspan="7"><textarea name="review[<?php echo $RES2['rid']; ?>]" cols="70" rows="6"><?php echo stripslashes(trim($RES2['review'])); ?></textarea>
			<select name="stars[<?php echo $RES2['rid']; ?>]" class="input">

                      <option value="0" <?php if ($RES2['stars']=="0") echo "selected"; ?>>0 stars</option>
                      <option value="1" <?php if ($RES2['stars']=="1") echo "selected"; ?>>1 star</option>
                      <option value="2" <?php if ($RES2['stars']=="2") echo "selected"; ?>>2 stars</option>
                      <option value="3" <?php if ($RES2['stars']=="3") echo "selected"; ?>>3 stars</option>
                      <option value="4" <?php if ($RES2['stars']=="4") echo "selected"; ?>>4 stars</option>
                      <option value="5" <?php if ($RES2['stars']=="5") echo "selected"; ?>>5 stars</option>
                  </select>
          <input type="submit" class="input" value="go"></td>
        </tr>
		<tr>
		  <td colspan="7"><hr></td>
		  </tr>
	  <?php } ?>
</table>
<input type="hidden" name="go" value="1"><br>
<br>

<input name="" type="submit">
</form>

and then update as follows:

if ($go==1) {


unset($i);
while($i=@each($review_name)) {
mysql_query("Update `reviews` SET `review_name` = '$i[1]' WHERE `rid` = '$i[0]'; ");
	}
unset($i);
while($i=@each($review_email)) {
mysql_query("Update `reviews` SET `review_email` = '$i[1]' WHERE `rid` = '$i[0]'; ");
	}
unset($i);
while($i=@each($review_title)) {
$i[1] = addslashes(htmlentities($i[1], ENT_QUOTES));
mysql_query("Update `reviews` SET `review_title` = '$i[1]' WHERE `rid` = '$i[0]'; ");
	}
unset($i);
while($i=@each($review_location)) {
mysql_query("Update `reviews` SET `review_location` = '$i[1]' WHERE `rid` = '$i[0]'; ");
	}
unset($i);
while($i=@each($review)) {
$i[1] = addslashes(htmlentities($i[1], ENT_QUOTES));
mysql_query("Update `reviews` SET `review` = '$i[1]' WHERE `rid` = '$i[0]'; ");
	}
unset($i);
while($i=@each($review_date)) {
mysql_query("Update `reviews` SET `review_date` = '$i[1]' WHERE `rid` = '$i[0]'; ");
	}

unset($i);
while($i=@each($stars)) {
mysql_query("Update `reviews` SET `stars` = '$i[1]' WHERE `rid` = '$i[0]'; ");
	}

unset($i);
while($i=@each($active)) {
mysql_query("Update `reviews` SET `active` = '$i[1]' WHERE `rid` = '$i[0]'; ");
	}


	unset($i);
	if (is_array($delete)) {
	while($i=each($delete)) {

	if ($i[1]=="delete")
		mysql_query("DELETE FROM `reviews` WHERE `rid` = '$i[0]'; ");

	}}
}

Can anyone help?

[nemonoman]

Could you explain what your problem is? What isn't working as you desire and expect?

[discostudio]

As you can see from my last post, I am doing it in 10 queries, I must be able to do it via a "while" loop in the following way:

while($i=each($array)) {

mysql_query("UPDATE `reviews` SET 
`review_name` = '$i[1]', 
`review_subject` = '$i[2]', 
`review_body` = '$i[3]' 
WHERE `id` = $i[0] ; ");

}

First of all is the above code correct? and secondly how should I set up the form row by row.

I pull the info out of the table as follows:

<form>
<?
$res = mysql_query("SELECT * FROM `reviews` ORDER BY `date` DESC");
while($r=mysql_fetch_array($res)) {
?>

<input type="text" name="[b]WHAT GOES HERE?[/b]{review_name} " value="<?php echo $r['review_name']; ?>">

<input type="text" name="[b]WHAT GOES HERE?[/b]{review_subject} " value="<?php echo $r['review_subject']; ?>">

<input type="text" name="[b]WHAT GOES HERE?[/b]{review_body} " value="<?php echo $r['review_body']; ?>">

<?php } ?>
</form>

Does that make a little more sense? LOL

[nemonoman]

First of all is the above code correct?

I can't swear that it's error free, but it's the exact right idea and will work after debugging.

how should I set up the form row by row?

You can create input arrays by using [] in the name

<input type=hidden name=idarray[] value=1>
<input type=text name=reviewname[] value='name1here'>

<input type=hidden name=idarray[] value=2>
<input type=text name=reviewname[] value='name2here'>

etc, etc.

When you submit the form, you'll have 2 arrays of inputs

$i=0;
$count=count($idarray);
while($i<$count){
$myid=$idarray[$i];
$myname=$reviewname[$i];
//do something with the data
$i++;
}

I recommend using "hidden" input as above when creating your form.