[SOLVED] while() stops script...

[eZe616]

I'm having this problem using the while() function to go through my database query results..

I currently have this

while($row = $db->fetchObject($result))
{ 
	$result[] = $row;						
}

 

Now when I use it like this, it just stops the rest of the page from loading. So i've been using the for() alternative, but I'd prefer to use the while function.

 

$db is the database class I use. That seems to be the cause, but I don't know why is causes it.

[mem0ri]

Looks like you have a doubling-up of variables...

 

while($row = $db->fetchObject($result)) //Notice the variable '$result'
{ 
$result[] = $row;  //Notice the same variable '$result'						
}

 

Basically...you're fetching the first row, and then setting your "result-set" to be = to the first row...thereby destroying your result-set and making the next iteration of the while statement 'stop'.