Please Help, Spliting the results of a query into four rows?

[irish21]

Does anyone know how i would go about recreating this effect?
http://www.faceparty.com/browse/browse.aspx

im using code something along the lines of this for single entrys but i want like four in a row.

   <?php

   include("config_members.php");

   $sql="SELECT * FROM User_infoT ";
   $result=mysql_query($sql);

   while($rows=mysql_fetch_array($result)){
   ?>
   <br />
   <table style="width: 100%" cellspacing="0" cellpadding="0">
   <tr>
   <td>
   <table>
   <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr>
   <tr><td class="proinfo"><a href="profile.php?username=<? echo $rows['Username']; ?>"class="newest"><? echo $rows['Username']; ?></a></td></tr>
   <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr>
   <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr>
   </table>
   </td>
   <td>
   <table>
   <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr>
   <tr><td class="proinfo"><a href="profile.php?username=<? echo $rows['Username']; ?>"class="newest"><? echo $rows['Username']; ?></a></td></tr>
   <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr>
   <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr>
   </table>
   </td>
   <td>
   <table>
   <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr>
   <tr><td class="proinfo"><a href="profile.php?username=<? echo $rows['Username']; ?>"class="newest"><? echo $rows['Username']; ?></a></td></tr>
   <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr>
   <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr>
   </table>
   </td>
   <td>
   <table>
   <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr>
   <tr><td class="proinfo"><a href="profile.php?username=<? echo $rows['Username']; ?>"class="newest"><? echo $rows['Username']; ?></a></td></tr>
   <tr><td class="proinfo"><? echo $rows['Location']; ?></td></tr>
   <tr><td class="proinfo"><? echo $rows['Fav']; ?></td></tr>
   </table>
   </td>
   </tr>
   </table>	
   <br />
   <?
   // close while loop
   }

   // close connection
   mysql_close();
   ?>

but obviously i am getting four of the same users in a row instread of four different users in each row and i cant get my head around how to do it to get individual users can anyone please help?

Thanks in advance

[scrupul0us]

try this (untested)

  <?php

   include("config_members.php");

   $sql="SELECT * FROM User_infoT ";
   $result=mysql_query($sql);

   $usersPerRow = 4;
   $counter = 1;
?>
   <br />
   <table style="width: 100%" cellspacing="0" cellpadding="0">
   <tr>

<?php  

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

if($counter%$usersPerRow == 0)
{
	echo '</tr><tr>'
}

 ?>
   <td>
   <table>
   <tr><td class="profilepicture"><img class="profile_pic"alt="" src="../Profile_pics/admin_pp.jpg" width="100" height="100" /></td></tr>
   <tr><td class="proinfo"><a href="profile.php?username=<?php echo $rows['Username']; ?>"class="newest"><?php echo $rows['Username']; ?></a></td></tr>
   <tr><td class="proinfo"><?php echo $rows['Location']; ?></td></tr>
   <tr><td class="proinfo"><?php echo $rows['Fav']; ?></td></tr>
   </table>
   </td>
   </table>	
   <br />
   <?
   $counter++;
   // close while loop
   }

   // close connection
   mysql_close();
   ?>
   </tr/>
   </table>