Ok - looking at what you did I cant see any diference apart from turning a
serious updated into a single update. This is usefull if I want to do an update
but I actualy want an insert (the update was just used for this example).
I actualy want to do an insert so i'me thinking the following would work:-
foreach ($insert as $table => $fields) {
foreach($fields as $field => $value) {
$columns[] = $field;
$values[] = "'".$value."'";
}
echo
"insert into $table ( ".implode( ', ', $columns ).
" values ( ".implode( ', ', $values )." ) ";
unset($columns);
unset($values);
}
Ben
>>> Brent Baisley <[EMAIL PROTECTED]> 01/11/05 03:02pm >>>
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
______________________________________________________________________
This email and any files transmitted with it are confidential. It is for the
intended recipient only. If you have received the email in error please notify
the author by replying to this email. If you are not the intended recipient,
you must not disclose, distribute, copy, print, or rely on this email. Any
views expressed by an individual within this email which do not constitute or
record professional advice relating to the RNLI, do not necessarily reflect the
views of the organisation.
Registered Charity Number 209603
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
