Page 1 of 1

Array Value

Posted: Mon Jan 12, 2009 12:18 am
by xionhack
Hello, let's say I have an array with the values

Array ( [147] => 1 [148] => [149] => 6 [150] => [151] => )

When trying to update a mysql database, let's say I have two fields 'id' and 'team_id'. What I want is for example, the one with the 'id' = 147, the team_id to be updated to '1', id 148 has nothing set so no update will happen, 149 will be updated to 6, 150 and 151 will have no change. How can I do that? Please let me know if you couldnt understand. Thanks.

Re: Array Value

Posted: Mon Jan 12, 2009 12:35 am
by requinix
You can use foreach to loop over the array. The key is the id and the value is the team_id.
Of course, only update if the value actually has a, er, value.

Re: Array Value

Posted: Tue Jan 13, 2009 1:58 am
by paqman

Code: Select all

 
<?
foreach($array as $id => $team_id)
{
     if(strlen($team_id) > 0)
     {
          //do something with the value
          echo $team_id." - ".$id."<br>";
     }
}
?>