Arrays - need to associate value in one with value in another for db insertion

Hi - I've got a form that is generated from db data and returns two separate arrays -

(arrID) Array ( [0] => 208 [1] => 210 [2] => 222 [3] => 225 [4] => 236 )
(arrStatus) Array ( [0] => 2 [1] => 3 [2] => 3 [3] => 4 [4] => 1 )

I need to combine or otherwise associate the data in the arrays so that I can properly update the db. For example, I need to do a query similar to:

update table set status = $arrStatus[0] where ID = $arrID[0]

but I want do be able to do this in a foreach statement, as the number of items returned can  differ each time the form is submitted.

Who is Participating?
steelseth12Connect With a Mentor Commented:

if(count($arrID) == count($arrStatus)) {
		mysql_query("update table set status = ".$arrStatus[$i]." where ID = ".$arrID[$i]);
	print "There was an error.<br> Items in Array arrID dont match items in Array arrStatus";

Open in new window

Opps extra ; on for($i=0;$i<count($arrID);$i++;){

please replace it with

If i understood right:

foreach($arrID as $key => $val){
	$sql = "update table set status = $arrStatus[$key] where ID = $value";
	//execute the sql

Open in new window

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

the above sql shoul look like this:
$sql = "update table set status = {$arrStatus[$key]} where ID = $value";

Open in new window

betagirlAuthor Commented:
@steelseth12 - perfect, just what I needed.

@exmanpl - i needed to associate the values of one array with the values of the  same key  of the other - your query handles only the one array.

No it handles both, you loop through one array and yose the current key value in the other.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.