Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

This is a nested array I got from my db,

Array
(
    [0] => Array
        (
            [Field] => blc_id
            [Type] => int(10) unsigned
            [Null] => NO
            [Key] => PRI
            [Default] => 
            [Extra] => auto_increment
        )

    [1] => Array
        (
            [Field] => blc_email
            [Type] => varchar(255)
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [2] => Array
        (
            [Field] => cat_id
            [Type] => varchar(255)
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [3] => Array
        (
            [Field] => blc_created
            [Type] => timestamp
            [Null] => NO
            [Key] => 
            [Default] => 0000-00-00 00:00:00
            [Extra] => 
        )

    [4] => Array
        (
            [Field] => blc_updated
            [Type] => timestamp
            [Null] => NO
            [Key] => 
            [Default] => CURRENT_TIMESTAMP
            [Extra] => on update CURRENT_TIMESTAMP
        )

)

How can I use foreach loop to get the result below,

Array
(
    [0] => blc_id
    [1] => blc_email
    [2] => cat_id
    [3] => blc_created
    [4] => blc_updated
)

Here is my code so far but of course it doesnt return the result correctly,

foreach($items as $outer_key => $array)
{ 
    foreach($array as $inner_key => $value)
    { 
        $field_name[] = $value; 
    } 
}

Thanks.

share|improve this question
1  
Why don't you alter your query rather than processing the result with PHP? –  Elwhis Mar 25 '11 at 15:03
 
I don't know how to alter my query... here it is - SHOW COLUMNS FROM root_blocks. thanks. –  lauthiamkok Mar 25 '11 at 15:16

4 Answers

up vote 5 down vote accepted

I guess you could use

foreach($items as $outer_key => $array)
{ 
    $field_name[] = $array['Field']; 

}
share|improve this answer
up vote 1 down vote

When you only need the first entry from each subarray:

$field_names = array_map("current", $outer_key);
share|improve this answer
up vote 1 down vote 
$fields = array();

foreach($input_array as $value)
  $fields[] = $value['Field'];

print_r($fields);
share|improve this answer
up vote 0 down vote 
array_map(create_function('$a','return $a["Field"];'),$a)
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.