Help: Loop over query result

Ik · 12-19-2010, 02:18 PM

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 · 12-20-2010, 01:12 PM

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

baxter · 12-21-2010, 05:15 PM

given the example it would be:

Code:

//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 · 12-22-2010, 03:46 AM

It works. Thank you

Originally Posted by baxter

given the example it would be:

Code:

//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 · 12-24-2010, 10:20 PM

Thanks the code is working with me.

12-19-2010, 02:18 PM	THREAD STARTER #1 (permalink)
Ik Quality // Join Date: Sep 2008 Posts: 911	Help: Loop over query result 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

12-20-2010, 01:12 PM	#2 (permalink)
nasaboy007 Senior Member Join Date: Jul 2005 Location: NJ Posts: 1,219	looks like its just a nested array. use the foreach() loop (nested) to pull out the data. __________________ Hacksar.com - Your source for random computer tips and tricks! MySiteMemberships.com - Keep track of your site registration information! Like my post? Rep is appreciated!

12-24-2010, 10:20 PM	#5 (permalink)
pausch NamePros Member Join Date: Nov 2010 Posts: 34	Thanks the code is working with me. __________________ Best Web Hosting \|\|Cheap Web Hosting \|\|WordPress Hosting

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to do a diff query for each value in a loop	DJ-Sound	Programming	5	10-19-2009 03:05 PM
overture question	Scorpio	Domain Newbies	2	09-25-2004 07:04 AM
Great Domain Typo Generator Script	jaydons	Scripts For Sale	2	08-20-2004 06:19 AM
Domain Typo Script	jaydons	Scripts For Sale	8	08-08-2004 10:49 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)