[RESOLVED] New row every 3 entries

rmurp006

I am somewhat new to php and am trying to learn how to make more of a community website, which involves adding friends to a profile. My problem is, when displaying all of the friends on a page, I would like a new row after every 3 entries. The code below isn't working and displays all the pictures on a separate row.

I have looked up similar issues to this and unfortunately I still can't figure it out. Any help would be great. Thank you.

The $offset can be ignored as it is only used for page numbers. That part works ha.

$query_page2 = "SELECT * FROM friendslist WHERE user_id='$userid' ORDER by lastname,firstname ASC LIMIT 12 OFFSET ".$offset;
$result_page2 = mysql_query($query_page2) or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
while ($row_page2 = mysql_fetch_array($result_page2))
{
$ffriendid = $row_page2["friend_id"];

$query_page3 = "SELECT * FROM members WHERE userid='$ffriendid' ORDER by userid ASC";
$result_page3 = mysql_query($query_page3) or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());

$count = 0;

while ($row_page3 = mysql_fetch_array($result_page3))
{
$userid2 = $row_page3["userid"];
$callsign2 = $row_page3["callsign"];
$pic = $row_page3["image"];

  if ($count%4 == 0)
  {
   echo "</tr><tr><td><a href='enlarge.php?view&id=$userid2'><img src='$pic' style='border-color: black' width='125'></a><br>$callsign2</td>";
   }
   else
   {
   echo "<td><a href='enlarge.php?view&id=$userid2'><img src='$pic' style='border-color: black' width='125'></a><br>$callsign2</td>";
	}
	$count++;

}}

intenz

$count = 0;
while( ... )
{
   $count++;

   do something

   if( $count == 3 )
   {
      do something every third entry

  $count = 0;
   }
}

rmurp006

Tried what you wrote and I ended up with this. do command I am not familiar with. When viewing this on the page, it doubled everyones picture as well. Sorry if I misunderstood what you wrote.

$query_page2 = "SELECT * FROM friendslist WHERE user_id='$userid' ORDER by lastname,firstname ASC LIMIT 12 OFFSET ".$offset;
$result_page2 = mysql_query($query_page2) or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
while ($row_page2 = mysql_fetch_array($result_page2)) 
{
$ffriendid = $row_page2["friend_id"];


$query_patrol = "SELECT * FROM members WHERE userid='$ffriendid' ORDER by userid ASC";
$result_patrol = mysql_query($query_patrol) or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());

$count = 0;

while ($row_patrol = mysql_fetch_array($result_patrol)) 
{
$userid2 = $row_patrol["userid"];
$callsign2 = $row_patrol["callsign"];
$pic = $row_patrol["image"];

$count++; 

{ echo "<td><a href='enlarge.php?view&picture_id=$picture_id'><img src='$pic' style='border-color: black' width='125'></a><br>$callsign2</td>"; 
   }

  do {echo "</tr><tr><td><a href='enlarge.php?view&picture_id=$picture_id'><img src='$pic' style='border-color: black' width='125'></a><br>$callsign2</td>";
}while ($count == 3) ;

  $count = 0; 
   }}

intenz

No dude, you're doing it wrong. "do" wasn't meant to be a command... The board just colored it by mistake. :evilgrin:

Something more like this...

$query_page2 = "SELECT * FROM friendslist WHERE user_id='$userid' ORDER by lastname,firstname ASC LIMIT 12 OFFSET ".$offset; 
$result_page2 = mysql_query($query_page2) or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error()); 
while ($row_page2 = mysql_fetch_array($result_page2)) 
{ 
	$ffriendid = $row_page2["friend_id"]; 


$query_patrol = "SELECT * FROM members WHERE userid='$ffriendid' ORDER by userid ASC"; 
$result_patrol = mysql_query($query_patrol) or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error()); 

$count = 0; 

while ($row_patrol = mysql_fetch_array($result_patrol)) 
{
	$count++; 

	$userid2 = $row_patrol["userid"]; 
	$callsign2 = $row_patrol["callsign"]; 
	$pic = $row_patrol["image"]; 

	if( $count == 3 )
	{
		echo "</tr><tr><td><a href='enlarge.php?view&picture_id=$picture_id'><img src='$pic' style='border-color: black' width='125'></a><br>$callsign2</td>"; 
		$count = 0;
	}
	else
		echo "<td><a href='enlarge.php?view&picture_id=$picture_id'><img src='$pic' style='border-color: black' width='125'></a><br>$callsign2</td>";
}
}

rmurp006

Thank you for rearranging that. Unfortunately, it still didn't work. However I did notice something. I dont think its counting right.

For every entry, it uses the 2nd echo. If I change the if( $count == 3 ) to if( $count == 1 ) , it starts using the first echo rather then the second for every entry.
It only uses one echo or the other, not both.

intenz

rmurp006;10963831 wrote:
Thank you for rearranging that. Unfortunately, it still didn't work. However I did notice something. I dont think its counting right.

For every entry, it uses the 2nd echo. If I change the if( $count == 3 ) to if( $count == 1 ) , it starts using the first echo rather then the second for every entry.
It only uses one echo or the other, not both.

Okay, something like this...

<?php
$query_page2 = "SELECT * FROM friendslist WHERE user_id='$userid' ORDER by lastname,firstname ASC LIMIT 12 OFFSET ".$offset;
$result_page2 = mysql_query($query_page2) or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());
while ($row_page2 = mysql_fetch_array($result_page2)) 
{ 
    $ffriendid = $row_page2["friend_id"]; 


$query_patrol = "SELECT * FROM members WHERE userid='$ffriendid' ORDER by userid ASC"; 
$result_patrol = mysql_query($query_patrol) or die ("<br /><br />There's an error in the MySQL-query: ".mysql_error());

$count = 0; 

while ($row_patrol = mysql_fetch_array($result_patrol)) 
{ 
    $count++; 

    $userid2 = $row_patrol["userid"]; 
    $callsign2 = $row_patrol["callsign"]; 
    $pic = $row_patrol["image"]; 

    echo "<td><a href='enlarge.php?view&picture_id=$picture_id'><img src='$pic' style='border-color: black' width='125'></a><br>$callsign2</td>"; 

	if( $count == 3 ) 
    {
        echo "</tr><tr><td><a href='enlarge.php?view&picture_id=$picture_id'><img src='$pic' style='border-color: black' width='125'></a><br>$callsign2</td>";
        $count = 0; 
    } 
} 
}

rmurp006

sorry. After putting in that code, it only uses the first echo. However when you change if( $count == 3 ) to if( $count == 1 ) again, it displays only the second echo and it doubles every image.

intenz

rmurp006;10963833 wrote:
sorry. After putting in that code, it only uses the first echo. However when you change if( $count == 3 ) to if( $count == 1 ) again, it displays only the second echo and it doubles every image.

You're clearly doing something wrong.

Take a look at this...

http://gxxx.is/.../while.php

This is what you want, right?

rmurp006

Ya thats what I'm looking for. Guess I'll mess with the code some more. I appreciate the help.

intenz

rmurp006;10963835 wrote:
Ya thats what I'm looking for. Guess I'll mess with the code some more. I appreciate the help.

Exactly.

I think you might consider removing the inner while loop and just do:

$row_patrol = mysql_fetch_array($result_patrol);

and implement my code in the "outer" loop.

rmurp006

Once I put everything on the outer loop it worked! Awesome.. thank you so much for the help! Guess it didn't like my second while loop!

intenz

Hehe, guess not. You're very much welcome. Glad that I could help. 🙂