Mysql Do while help needed

[Phunky]

I would like to repeat a Mysql Database call but i cant get my head round how you would do the Do { while thingy! plz help

<?php
#### Query the vwar_member db  table
$members_query = "SELECT * FROM vwar_member"; 
$members_result = mysql_query($members_query) 
or die(mysql_error()); 
#### setting the row print thingy
$members_printrow = mysql_fetch_row($members_result) ;

$memberstatus_query = " SELECT * FROM vwar_memberstatus WHERE statusid = $members_printrow[11] "; 
$memberstatus_result = mysql_query($memberstatus_query) 
or die(mysql_error()); 
#### setting the row print thingy
$memberstatus_printrow = mysql_fetch_row($memberstatus_result) ;
?>	

<div class="dateheader">British Born Killers Roaster</div>

<table cellpadding="3" cellspacing="2" width="100%">
######
###### repeat starts here	
######	
		<tr class="bgTwo">
			<td width="20px" class="bgOne"><?php echo $members_printrow[2]; ?></td>
			<td><?php echo $memberstatus_printrow[1]; ?> </td>
			<td><?php echo $memberstatus_printrow[1]; ?> </td>
			<td><a href="index.php?thepage=profile&plid=<?php echo $members_printrow[0]; ?>">Details</a></td>
		</tr>
######
###### repeat ENDS here	
######			
	</table>

please help!

[volleytotal_ch]

do it with just one query! Replace the words in UPPERCASE corresponding your database structure ..

<?
//#### Query
$members_query = "SELECT m.*, s.* FROM vwar_member m, vwar_memberstatus s WHERE  s.statusid = m.MEMBERSTATUS_IN_MEMBERTABLE";
$res = mysql_query($members_query) or die(mysql_error());
if(mysql_num_rows($res)==0)
{
  echo "no members found!";
}
else
{
  // Found members -> display them!
?>    

<div class="dateheader">British Born Killers Roaster</div>

<table cellpadding="3" cellspacing="2" width="100%">
<?
//######
//###### repeat starts here    

//######
  while($row = mysql_fetch_array($res))
  {
?>    

        <tr class="bgTwo">
            <td width="20px" class="bgOne"><?php echo $row["SOMEROW"]; ?></td>
            <td><?php echo $row["SOMEROW"]; ?> </td>
            <td><?php echo $row["SOMEROW"]; ?> </td>
            <td><a href="index.php?thepage=profile&plid=<?php echo $row["SOMEROW"]; ?>">Details</a></td>
        </tr>
<?
//######
//###### repeat ENDS here    

//######            

  }
?>
    </table>
<?
} // End members display
?>