Hi there, Well i completely agree with rahul you can use directly while loop for fetch each row from the database then y u using for each inside may be both loop conflicts that's y loop didn't work if u just want run program anyhow then you can use while loop directly ________________________________ From: rahul dongre <mady_dongre@xxxxxxxxxxx> To: php-objects@xxxxxxxxxxxxxxx Sent: Mon, 30 November, 2009 1:28:04 PM Subject: Re: Problem with while y r using foreach inside d while.u can use while($row = mysql_fetch_ object($rs) ){ $row->[your colom name]; }you can use like this plz ignore this if i am not interpreted ur problem properly . Rahul Dongre Software Engineer Consagous Technologies Pvt. Ltd. --- On Mon, 30/11/09, hno <hno2005@gmail. com> wrote: From: hno <hno2005@gmail. com> Subject: Problem with while To: php-objects@ yahoogroups. com Date: Monday, 30 November, 2009, 12:04 PM HI How can have a while and a foreach in it? I have something like this: While($row=mysqli_ fetch_assoc( $r)){ // code Foreach($row[ 'key'] as $value){ //code } } But the while loop run just one time and I'm sure it should run more than one time and I know the problem is with the foreach .by the way,I can't delete the foreach from the while because It works with each row from the while loop. Does anybody has any idea about it? thanks image002 HNO [Non-text portions of this message have been removed] The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo. com/ [Non-text portions of this message have been removed] The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/ [Non-text portions of this message have been removed]