Posted by Brent Baisley on 10/04/77 11:05

You've created a 2x2 array, not a 1x4, which might be confusing you:
tab2 ["fields1"] ["fields5"]
tab1 ["fields2"] ["fields7"]

You almost have it, you just need to set your loop up to handle
unlimited field/value pairs in your array.

One option is to structure your loop like this:
foreach ($insert as $table => $fields) {
foreach($fields as $field => $value) {
$fieldValuePairs[] = "$field = $value";
}
$fieldValueStr = implode(',', $fieldValuePairs);
echo "update $table set $fieldValueStr";
unset($fieldValuePairs);
}

On Jan 11, 2005, at 6:22 AM, Benjamin Edwards wrote:

> If I create the following 2 dimensional associative array:-
>
> $insert["tab2"]["fields1"] = "value1";
> $insert["tab1"]["fields2"] = "value2";
> $insert["tab2"]["fields5"] = "value3";
> $insert["tab1"]["fields7"] = "value4";
>
> how do I do 2 levels of nested loop with the first level looping
> through the first level of the array and the second nesting through
> the second. something like:-
>
> foreach( $insert as $table => $fields ) {
> foreatch( $fields as $field => $value ) {
> echo "update $table set $field = $value";
> }
> }
>
> Regards,
> Ben
>
>
>
>
>
>
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577

[Back to original message]