limit array to 3

[shorty3]

ive coded this

 

          <? 

$query_friends=mysql_query("SELECT * FROM friends WHERE username='$viewuser' AND type='Friend'");


	$rows=mysql_num_rows($query_friends);

if ($rows == "0"){ echo "<center>No friends</center>"; }
while($dip=mysql_fetch_object($query_friends)){
echo "  <a href='profile.php?viewuser=$dip->person'>$dip->person</a>,";
	  }
	  ?>

 

but i want it to have a limit of 3 friends in a row and then a <br> and so on

 

example what its doing now username, username, username, username.................

 

 

what i want it to do is

username, username, username

username, username, username

username, username, username

 

 

and also how can i have it add up all the friends so i can have example: friends 83

 

somthing like

 <?php echo "$rows";?>

[trq]

See http://www.phpfreaks.com/forums/index.php/topic,95426.0.html

[shorty3]

im still none the wiser i dont know how to implement that in the code i have, with the help you gave me

[mattyvx]

you need to set a variable to start with before your while loop, check if it is divisible by 3, then increment

 

<?
$rows=mysql_num_rows($query_friends);

if ($rows == "0"){ echo "<center>No friends</center>"; }

$friend = 0;
while($dip=mysql_fetch_object($query_friends))
{
echo ($friend % 3 == 0)? "<br/>" : ""; // checks if friend number is a multiple of three if yes echo <br/> if not echo nothing
echo "  <a href='profile.php?viewuser=$dip->person'>$dip->person</a>,"; // echo link to friend profile
$friend++; // increase friend count	
}
?>

 

That should work i think (not tested)