jenslm: zwei do-while-schleifen

Beitrag lesen

also sowas hier funktioniert ja leider nicht:

  
  
if(isset($_GET['parameter']))  
{  
	$parameter = $_GET['parameter'];  
	$sql = "SELECT COUNT(id) FROM tab1 WHERE parameter = '$parameter' AND lang = '$lang'";  
	$result = mysql_query($sql);  
	$number = mysql_result($result, 0);  
	  
	if($number != 0)  
	{  
		$sql = "SELECT id, name FROM tab1 WHERE lang = '$lang'";  
		$result = mysql_query($sql, $database) or die(mysql_error());  
		$row = mysql_fetch_assoc($result);  
  
		do  
		{  
			if($row['id'] == $parameter)  
			{  
				echo "<li><a class=\"active\" href=\"irgendwohin\">".$row['name']."</a></li>\n";  
				  
				$sql = "SELECT id, name FROM tab2 WHERE lang = '$lang'";  
				$result = mysql_query($sql, $database) or die(mysql_error());  
				$row = mysql_fetch_assoc($result);  
				  
				echo "<ul>";  
				  
				do  
				{  
					echo "<li><a href=\"irgendwohin\">".$row['name']."</a></li>\n";  
				}  
				while ($row = mysql_fetch_assoc($result));  
				  
				echo "</ul>";  
				  
			}  
			  
			else  
			{  
				echo "<li><a href=\"irgendwohin\">".$row['name']."</a></li>\n";  
			}  
		}  
		while ($row = mysql_fetch_assoc($result));  
	}  
	  
	else  
	{  
		//unwichtig  
	}  
}  
  

wie koennte ich das loesen?
lg, jens