Help: Loop over query result

[Ik]

Hi,

Please help me with this.

http://mbe.ro/2009/08/30/fast-and-easy-php-mysql-class/

Code Line 129 //method to select (clean and beautiful)

The author has put a sample result, but I just don't know how to loop over the results to display the records on my PHP page.

Pls help
Thanks

 

[nasaboy007]

looks like its just a nested array. use the foreach() loop (nested) to pull out the data.

 

[baxter]

given the example it would be:

//method to select (clean and beautiful)
$result = $m->select(array(
	'table' => 'users',
	'condition' => 'active=1 AND type=1'
));

foreach ($result as $row) {
   //The data is in $row['user'] where user is the mysql table name
   //so if there was a field username you would retrieve it like this
   $username = $row['user']['username'];
}

 

[Ik]

It works. Thank you

given the example it would be:

//method to select (clean and beautiful)
$result = $m->select(array(
	'table' => 'users',
	'condition' => 'active=1 AND type=1'
));

foreach ($result as $row) {
   //The data is in $row['user'] where user is the mysql table name
   //so if there was a field username you would retrieve it like this
   $username = $row['user']['username'];
}

 

[pausch]

Thanks the code is working with me.