0

hello,
I have found a set of functions to return values from mysql queries. I have the array filled but I am not sure how I am going to display the data. Any help is greatly appreciated.

$db->select('awf_users');
print_r($db->result);

my result is:

Array ( [0] => Array ( [id] => 42 [name] => Super User [username] => admin [email] => someemail@email.com [password] => df75c57cf80150f57db3f7361202b729 [usertype] => deprecated [block] => 0 [sendEmail] => 1 [registerDate] => 2011-05-09 21:19:05 [lastvisitDate] => 2011-05-10 05:07:06 [activation] => [params] => ) [1] => Array ( [id] => 43 [name] => ralph [username] => rb [email] => anotheremail@email.com [password] => 79ea2ac31af038ca9af9143f6c837b9a:YjwDbTZFUPpLIGums8LCBD49zp4eAxtq [usertype] => [block] => 0 [sendEmail] => 0 [registerDate] => 2011-05-10 05:26:10 [lastvisitDate] => 0000-00-00 00:00:00 [activation] => [params] => {} ) )

Ralph

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by ProfessorPC
0

wow I am sorry for this post. Not sure what I was thinking. Anyway, the fix to display it all:

$rs = $db->result;
foreach( $rs as $key => $value){
	if(is_array($value)){
		foreach($value as $key1 => $res){
			echo $res . "<br>";
		}
	}
}
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.