Array's

[bradynorman]

Hi,

 

I am using the following code;

 

 

mysql_select_db($database_grcdb, $grcdb);

foreach($id as $val) {

  $val2=$_POST['bin'];

  $query = "UPDATE stock SET status = 'warehouse' SET bin = '$val2'  WHERE id = '$val'";

  mysql_query($query) or die(mysql_error());

}

mysql_close();

$updateGoTo = "stock.php";

header(sprintf("Location: %s", $updateGoTo));

 

 

the error i get is ;

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET bin = 'Array' WHERE id = '6'' at line 1

 

the form is submitted with to variables id[] and bin[]

 

What am i doing wrong so that the $bin is not updated each time the loop runs?

 

cheers

Mike

 

[DarkWater]

$bin is an array, and you can't put an array into a string.  You need to loop it.

[akitchin]

i am locking this thread.  please do not double-post; bump your other topic if absolutely necessary.  you've received a reply in the other thread.