[SOLVED] Problem with loop and sql update

[jaxdevil]

Below is the code I am trying. Have not used loops very much so someone else will be able to easily figure this out. I have a form that posts the data to this page. The from fields are in the first code box below and the second is the update query where I am trying to use the loops. It is not right, breaks the code each time so I am not formatting something right:

 

?>
<input type="hidden" name="start" value="<?=$start?>">
<input type="hidden" name="end" value="<?=$end?>">
<input type="hidden" name="id[]" value="<?=$id?>">
<input type="hidden" name="scan_code[]" value="<?=$scan_code?>">

 

<?
require($_SERVER['DOCUMENT_ROOT'].'/includes/configs/sql_connect.php');
for ($x = $start; $x >= $end; $x++) {
      $query="UPDATE inventory SET `scan_code` = '$scan_code[]' WHERE id='$id[]'";
           $result =mysql_query($query) or die ("Problem with the query $query<br>: " . mysql_error());
} // end for
?>

[F1Fan]

I see two problems, and they both have to do with the arrays in your query.

 

1st, you're not using a key in the array, instead just [] ($scan_code[]) and you're not using {} brackets around the arrays.

[Maq]

Have you defined $start and $end yet?  If not you need to use the POST methods.

 

for ($x = $_POST_['start']; $x >= $_POST['end']; $x++) {

[jaxdevil]

Thanks.

 

I think I found something that would make sense, a foreach loop, but how can I define it with 2 post infos? I.e I have $id AND $scan_code and this would only work for looping base don ID:

 

 foreach($id as $ids) {  
echo "$ids <br />";  
}  

 

So how could I use that for both $id AND $scan_code ?

[F1Fan]

<?php
foreach($id as $k=>$ids) {
  echo "$ids <br />";
  echo "{$scan_code[$k]} <br />";
}
?>

[jaxdevil]

You da man!

 

Thanks!