Looping through objects

reeksy

Im trying to loop through a query and on each loop run a seperate query.

Here's my loop:

while ($row = $db->fetchObject()){

// My query here

}

Here's my loop with the query:

while ($row = $db->fetchObject()){

 $qry = "SELECT * FROM `tablename` WHERE row= '".$row->id."'";

 $db->query($qry);

}

The problem is when i loop through $row->id loses its value after the first loop causing the other querys below it to break.

Does anyone know why this would happen?

Here's my function within the class if this helps:

	function query($qry) {
    	$this->obj = @mysql_query($qry);
    	if (!$this->obj){
			print '<strong>Query failed:</strong><br />'.$qry;
			print '<br /><br /><strong>MySQL error:</strong><br />'.mysql_error();
			exit;
		}
        return $this->obj;
    }

laserlight

One way is to have another database object handle the inner queries. Another way would be to store the results of the first query in an array, then run queries on the array contents. Yet another way would be to incorporate the outer and inner queries into one query, if it is possible.

reeksy

OK thanks.

Ive created a new object to handle inner queries. Not ideal as you have to create two more functions like so:

	function innerQuery($qry) {
    	$this->obj2 = @mysql_query($qry);
    	if (!$this->obj2){
			print '<strong>Query failed:</strong><br />'.$qry;
			print '<br /><br /><strong>MySQL error:</strong><br />'.mysql_error();
			exit;
		}
        return $this->obj2;
    }


 function fetchInnerObject() {
 	$row = @mysql_fetch_object($this->obj2);
	return $row;
}

But this will probably run quicker than building and using the contents of an array.

Weedpacket

reeksy wrote:
But this will probably run quicker than building and using the contents of an array.

Not if you're using innerQuery() inside a loop 🙂