RE: [PHP] accessing data from an array within an array.

[admin]

I would suggest you print out the array to get a better understanding of the
structure first.

Print_r('<PRE>');
Print_r($array);
Print_r('<PRE>');


You can foreach over the $array['row'] 

Foreach($array['row'] as $key=>$values)
{
        Echo $values.PHP_EOL;
}
                        



Richard L. Buskirk

-----Original Message-----
From: Adam Preece [mailto:a...@blueyonder.co.uk] 
Sent: Saturday, May 07, 2011 11:37 AM
To: php-general@lists.php.net
Subject: [PHP] accessing data from an array within an array.

hello all.

im trying to make a function that fetches all rows in the database and
stores each row (Array) within an array.

so the code is as follows: 

public function fetch_all($table_name,$order = "DESC"){
                        $array['row'] = array();
                        strtoupper($order);
                        $query = "SELECT * FROM `{$table_name}` ORDER BY id
{$order}";
                        $result = $this->gen_query($query);
                        while($row = $this->fetch_assoc($result)){
                                $array['row'][] = $row;
                        }
                        
                        if($this->sql_error_check($result)){
                                return $array;
                        }
                }

this returns (ill just paste 1 row for the sake of the email length:

Array ( [row] => Array ( [0] => Array ( [id] => 9 [name] => TESTER [title]
=> TESTER [heading] => TESTER [text] =>

TESTER
[gallery_id] => 0 [meta_desc] =>

TESTER
[meta_keywords] => TESTER [meta_author] =>

 

TESTER
[page_id] => 0 [date_time] => 2011-05-07 06:49:39 [image] =>
[user_access_id] => 1 ) 

How do i access each array within the array and throw out the data for each
one.

im pretty confused on this one.

any help would be appreciated.

Adam
-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php