Member Avatar for Ole Raptor

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
  • 125 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Ole Raptor
Member Avatar for Ole Raptor

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>";
		}
	}
}
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.