$iTotalPages )
$iCurPage = $iTotalPages;
if( $iCurPage < 1 )
$iCurPage = 1;
$sLimitFrom = ( $iCurPage - 1 ) * $iPerPage;
$sqlLimit = "LIMIT {$sLimitFrom}, {$iPerPage}";
////////////////////////////
$friend_list_query = "
SELECT p.*
FROM `Profiles` AS p
LEFT JOIN `FriendList` AS f1 ON (f1.`ID` = p.`ID` AND f1.`Profile` ='{$iID}' AND `f1`.`Check` = 1)
LEFT JOIN `FriendList` AS f2 ON (f2.`Profile` = p.`ID` AND f2.`ID` ='{$iID}' AND `f2`.`Check` = 1)
WHERE 1
AND (f1.`ID` IS NOT NULL OR f2.`ID` IS NOT NULL)
ORDER BY p.`Picture` DESC
{$sqlLimit}
";
$friend_list_res = db_res("$friend_list_query");
$iCounter = 0;
while ( $friend_list_arr = mysql_fetch_assoc( $friend_list_res ) )
{
$iCounter ++;
$sKey = '1';
if( $iCounter == 3 )
{
$sKey = '1';
}
$ret .= '