Query refuses to recurse all rows

[celtic@xxxxxxxxxx]

Hi,
 
In the following code, only the first row from query1 displays along with the 
display stuff from query3. The problem: query1 refuses to recurse to the next 
and following rows. 

It appears that the sub-queries in the main query cause the $row++; not to 
work.

Is there some conditional that might it prompt it to do so? 

I'm stumped - worked at variations for a few days. Any help, pointers, 
suggestions most gratefully welcome!



<?php

include("dbc.php");
if (!$db){ $_SESSION['db'] = "select-thread"; session_write_close(); 
header("location: db.php");}

	$query1 = "SELECT * FROM replies WHERE mid = '{$_SESSION['mid']}'";
							
		$result1 = pg_exec($db, $query1);
		if (!$result1) { exit;}
	
		$numrows1 = pg_numrows($result1);
		$row = 0;
		do
		{
			$myrow = pg_fetch_array($result1, $row);	
	
				/* display stuff */



				$query2 = "SELECT * FROM subs WHERE mid = '{$_SESSION['mid']}' AND 
						rid = '{$myrow['rid']}'";

					$result2 = pg_exec($db, $query2);
					if (!$result2) { exit;}
				
					$numrows2 = pg_numrows($result2);
					$row = 0;
					do
					{
						$myrow = pg_fetch_array($result2, $row);	
		
							/* display stuff */
	
					$row++;
					}
					while ($row < $numrows2);
	
	
	
	
				$query3 = "SELECT * FROM subs where subsid = '{$_SESSION['subsid']}' 
						AND rid = '{$myrow['rid']}' AND responded = '1'";
	
					$result3 = pg_exec($db, $query3);
					if (!$result3) { exit;}
				
					$numrows3 = pg_numrows($result3);
					$row = 0;
					do
					{
					$myrow = pg_fetch_array($result3, $row);	
	
						/* display stuff */
	
					$row++;
					}
					while ($row < $numrows3);....

		
		$row++;		
		}
		while ($row < $numrows1);

?>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php