<tmpl_loop name=team>
<tmpl_var name=name>

<tmpl_loop name=member>
<tmpl_var name=username>


</tmpl_loop>
</tmpl_loop>

<?
session_start();
include("admin/inc/con.inc.php");
include("admin/inc/config.inc.php");
include("admin/vlib/vlibTemplate.php");
$tmpl = new vlibTemplate("tmpl/team_list.tmpl");

$query = mysql_query ("select * from sq ORDER BY name ASC");
$rows = mysql_num_rows($query);
$team = array();
while($d= mysql_fetch_array($query)) {
    foreach($d as $k=>$v) {
		$d[$k] = nl2br($d[$k]);
}
        extract($d);
        array_push($team, array(
            'id' => $id,
            'rows' => $rows,
            'name' => $name,
		)
	);

	$query2 = mysql_query ("select * from login WHERE member='$d[name]'");
	$rows2 = mysql_num_rows ($query2);
	$member = array();
	while($d2= mysql_fetch_array($query2)) {
	    foreach($d2 as $k2=>$v2) {
			$d2[$k2] = nl2br($d2[$k2]);
	}
	        extract($d2);
	        array_push($member, array(
			'id' => $id,
			'username' => $username,
	                'email' => $email,
	                'rows2' => $rows2,
	                'status' => $status,
	                'aufgabe' => $aufgabe,
			)
		);
	}
}
$tmpl-> setloop('member', $member);
$tmpl-> setloop('team', $team);

$tmpl->pparse();
?>