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@xxxxxxxxx> wrote: From: hno <hno2005@xxxxxxxxx> Subject: Problem with while To: php-objects@xxxxxxxxxxxxxxx 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]