making a loop

[zhshero]

Hey i'm just wanting to make a loop to loop members i do have a loop but im looking for a more better loop

i need to loop my members in a table as

 

spot: 1  spot: 2 spot: 3 spot 4

and if there more it puts in below the top for spots and so on

 

$Members = mysql_query("SELECT * FROM users") or die(mysql_error());

$numRowsMembers = mysql_num_rows($Members);
?>

<?php
     for($count = 1; $count <= $numRowsMembers; $count++)
         {

    $name = mysql_fetch_array($Members);

?>

<td width="150" height="125">
<a href="view_profile.php?username=<? echo $name['Username']?>"><img src="<? echo $name['main_P']?>" width="100" height="100"/>
<? echo $name['Username']?></a>

<? } ?>

[revraz]

Check out FOREACH

[zhshero]

i already have checked it out

[revraz]

Ok.. use FOREACH

[zhshero]

can you show me an example?

[revraz]

http://www.tizag.com/phpT/foreach.php

[MrXHellboy]

$Members = mysql_query("SELECT * FROM users") or die(mysql_error());

while ($r = mysql_fetch_array($Members))
// Your code here.

    

$numRowsMembers = mysql_num_rows($Members);

[nayan]

$Members = mysql_query("SELECT * FROM users") or die(mysql_error());

 

$numRowsMembers = mysql_num_rows($Members);

?>

 

<?php

    while($name = mysql_fetch_array($Members)){

 

?>

 

<td width="150" height="125">

<a href="view_profile.php?username=<? echo $name['Username']?>"><img src="<? echo $name['main_P']?>" width="100" height="100"/>

<? echo $name['Username']?></a>

 

<? } ?>