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.

Thanks!
betagirlAsked:
Who is Participating?
 
steelseth12Connect With a Mentor Commented:

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

Open in new window

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

please replace it with

for($i=0;$i<count($arrID);$i++){
0
 
eXman_plCommented:
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

0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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

Open in new window

0
 
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.

0
 
eXman_plCommented:
No it handles both, you loop through one array and yose the current key value in the other.
0
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.