Problem mit einem Memberscript...

[lucas]

Hi,

wie man im Titel schon lesen kann habe ich nen Problem mit einem memberscript, es wird pro Team immer nur ein Member ausgelesen, obwohl ich mehrere member in der db eingetragen habe.
Hier ist der Code :

<? 

// teams auslesen

include ('../../include/var.inc.php'); 
include ('../../include/connect.php'); 


$q="SELECT * from ".$tag."_teams order by t_ID"; 



$result= mysql_db_query($dbase, $q, $connection) or die 
("Could not execute query : $q." . mysql_error()); 

while ($row=mysql_fetch_array($result)) 
{ 


$t_ID=$row["t_ID"]; 
$t_name=$row["t_name"]; 
$t_game=$row["t_game"]; 

// member auslesen

$q2 = "SELECT * FROM ".$tag."_members WHERE m_teamID=".$t_ID." "; 
$rs2 = mysql_query($q2); 
$fmem = mysql_fetch_array($rs2); 

$m_ID=$row["m_ID"]; 
$m_nick=$fmem["m_nick"]; 
$m_status=$fmem["m_status"]; 
$m_task=$fmem["m_task"]; 



?> 

<br> 
<table width="500" border="0" align="center" cellpadding="0" cellspacing="0" class="whole"> 
  <tr> 
    <td><table width="100%" border="0" cellspacing="1" cellpadding="2"> 
        <tr class="row1"> 
          <td height="20"><strong><? echo"$t_name - $t_game"; ?></strong></td> 
        </tr> 
        <tr class="row2"> 
          <td height="18"><table width="100%" border="0" cellspacing="0" cellpadding="0"> 
              <tr> 
                <td width="32%" height="18">Nick :</td> 
                <td width="15%"><div align="center">Status :</div></td> 
                <td width="38%"><div align="center">Task :</div></td> 
                <td width="15%"><div align="right">Options :</div></td> 
              </tr> 
            </table></td> 
        </tr> 
        <tr class="row1"> 
          <td> 
          <table width='100%' border='0' cellspacing='0' cellpadding='0'> 

<? // Member auflisten 

          echo " 
              <tr> 
                <td width='32%' height='18'>$m_nick</td> 
                <td width='15%'><div align='center'>$m_status</div></td> 
                <td width='38%'><div align='center'>$m_task</div></td> 
                <td width='15%'><div align='right'><a href='mdetaisl.php?memberID=$m_ID'>
<font color='#666666'>more</font> »</a></div></td> 
              </tr> 
            "; 

?>           
         
        </table> 
            </td> 
        </tr> 
      </table></td> 
  </tr> 
</table> 
<? 
} 
?>

wäre nett, wenn mir einer von euch helfen könnte

Lucas

 

[mAu]

<br>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="0" class="whole">
  <tr>
    <td><table width="100%" border="0" cellspacing="1" cellpadding="2">
        <tr class="row1">
          <td height="20"><strong><? echo"$t_name - $t_game"; ?></strong></td>
        </tr>
        <tr class="row2">
          <td height="18"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td width="32%" height="18">Nick :</td>
                <td width="15%"><div align="center">Status :</div></td>
                <td width="38%"><div align="center">Task :</div></td>
                <td width="15%"><div align="right">Options :</div></td>
              </tr>
            </table></td>
        </tr>
        <tr class="row1">
          <td>
          <table width='100%' border='0' cellspacing='0' cellpadding='0'>

  <?

// teams auslesen

include ('../../include/var.inc.php');
include ('../../include/connect.php');


$q="SELECT * from ".$tag."_teams order by t_ID";



$result= mysql_db_query($dbase, $q, $connection) or die
("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result))
{


$t_ID=$row["t_ID"];
$t_name=$row["t_name"];
$t_game=$row["t_game"];

// member auslesen

$q2 = "SELECT * FROM ".$tag."_members WHERE m_teamID=".$t_ID." ";
$rs2 = mysql_query($q2);
while($fmem = mysql_fetch_array($rs2)){

$m_ID=$row["m_ID"];
$m_nick=$fmem["m_nick"];
$m_status=$fmem["m_status"];
$m_task=$fmem["m_task"];

          echo "
              <tr>
                <td width='32%' height='18'>$m_nick</td>
                <td width='15%'><div align='center'>$m_status</div></td>
                <td width='38%'><div align='center'>$m_task</div></td>
                <td width='15%'><div align='right'><a href='mdetaisl.php?memberID=$m_ID'>
<font color='#666666'>more</font> »</a></div></td>
              </tr>
            ";
	}
}
?>

        </table>
            </td>
        </tr>
      </table></td>
  </tr>
</table>

Du musst das mit ner while schleife machen... schau dir einfach meinen code an, sollte so gehen, aber keine Garantie dafür

 

[lucas]

jo, danke

es geht

Lucas