mySql to HTML table using PHP

[jacko310592]

hey guys, i have a query set up to retreve user details, but now i need to put these details into a HTML table, set out like this..

 

user1 | user2 | user3 | user4 | user5

------------------------------------------------

user6 | user7 | user8 | user9 | user10

 

...so every 5th result starts a new row (<tr>)

 

all i have at the moment is a simple mysql array output:

while($result = mysql_fetch_array($search))
{
 	echo $result['username'];
}

 

can anyone help with this please?

thanks

[mikesta707]

$count = 0;
echo "<table><tr>";
while($result = mysql_fetch_array($search))
{
 	echo "<td>".$result['username']."</td>";
                if (($count + 1) % 5 == 0)
                        echo "</tr><tr>";
                $count++;
}
echo "</tr></table>";

 

 

something like that should do the trick

 

EDIT: forgot to increment count and fixed a syntax error

[jacko310592]

thanks a lot mikesta707, that did it nicely  (: