[Resolved] Limiting an array

SureFire

Ok, I'm stumped, I'd like for my page to display up to 2 rows of four members, but if there are more than 8 members, I'd like 8 listed and a link to a "view all members" page.

<?php  

define('ITEMS_PER_PAGE', 4); 


mysql_connect(localhost,$username,$password);  

@mysql_select_db($database) or die( "Unable to select database"); 
$query = "SELECT * FROM websitefriends WHERE friend1='$siteusername'";  

$result = mysql_query($query); 
$item = 0;  

while($row = mysql_fetch_array($result)){ ?> 

<td align="center" valign=top width=20%>
<FONT face="Arial, Helvetica" size=3 color="White">
 <a href="profile.php?siteusername=<? echo $row['friend2'] ?>">

<font color=224982><? echo $row['friend2'] ?></a>
<br>
<a href="profile.php?siteusername=<? echo $row['friend2'] ?>">
<img src="<? echo $row['picture'] ?>.jpg" width=100 border=0></a> 

</td>



<?
      if($item == ITEMS_PER_PAGE - 1){ 
        $item = 0; 
        echo '</tr><tr>'; 
    } else { 
        $item++; 
    } 

}


mysql_close();  

?>

That lets me display as many rows of four as there are members, but I'd like to stop at two rows(8 members)...any ideas?

Installer

Although it needs more work, this code should do it:

$siteusername = 'username';
define('ITEMS_PER_ROW', 4);
$default_rows_per_page = 2;

mysql_connect(localhost,$username,$password);   

@mysql_select_db($database) or die( "Unable to select database");  

$query = "SELECT * FROM websitefriends WHERE friend1='$siteusername'";   

$result = mysql_query($query);  

$num_rows = mysql_num_rows($result);

if (isset($_GET['all'])) {
    define('ROWS_PER_PAGE', ceil($num_rows / ITEMS_PER_ROW));
} else {
    define('ROWS_PER_PAGE', $default_rows_per_page);
}

$item = 1;
$table_row = 1;   

echo '<table><tr>';
while ($row = mysql_fetch_array($result)) { 
    echo '<td align="center" valign="top" width="20%">' . 
         '<font face="Arial, Helvetica" size="3" color="White">' . 
         '<a href="profile.php?siteusername=' . $row['friend2'] . '">' . 
         '<font color="224982">' . $row['friend2'] . '</a>' . 
         '<br>' . 
         '<a href="profile.php?siteusername=' . $row['friend2'] . '">' . 
         '<img src="' . $row['picture'] . '.jpg" width="100" border="0" /></a>' . 
         '</td>'; 
    if ($item++ >= ITEMS_PER_ROW) {
        $item = 1;  

        echo '</tr><tr>';
        if ($table_row++ == ROWS_PER_PAGE) {
            break;
        }  

    }
}
if ($item < ITEMS_PER_ROW) {
    for ($i = $item; $i < ITEMS_PER_ROW; $i++) {
        echo '<td></td>';
    }
} 
echo '</tr></table><br />';

if (isset($_GET['all'])) {
    echo '<a href="' . $_SERVER['PHP_SELF'] . '">' .
         'Display first ' . ITEMS_PER_ROW * $default_rows_per_page . '</a>';
} else {
    echo '<a href="' . $_SERVER['PHP_SELF'] . '?all=1">Display all</a>';
}

mysql_close();

Your next question might be how to show the next eight, then the eight after that, etc. If so, search the forum and/or google for "pagination".

SureFire

I find it incredible that people take the time to help with something like this, thank you