добавете ми страницизиране на това

[bankera1990]

моля ви направете ми го да се станицизира

<?php 
$user=$_SESSION['username']; 
$db=mysql_query("SELECT * FROM users WHERE username='$user' LIMIT 10"); 
while ($r=mysql_fetch_array($db)) 
{ 
$id=$r['id']; 
} 
$sql=mysql_query ("SELECT * FROM frends WHERE uid='$id' LIMIT 10"); 
$frends=mysql_num_rows($sql); 
if ($frends > 0) 
{ 
echo '<table width="40%"><tr>'; 
while ($r=mysql_fetch_array($sql)) 
{ 
$fid=$r['fid']; 
$sql2=mysql_query ("SELECT * FROM users where id='$fid' LIMIT 10"); 
while ($r2=mysql_fetch_array($sql2)){ 
$count++; 
$id=$r['id']; 
$user=$r2['username']; 
$picture=mysql_query("SELECT picture FROM users WHERE username='$user'") or die(mysql_error()); 
$picturerow=mysql_fetch_array($picture); 
// тук и други може да си добавяш 
if($picturerow[picture] == NULL) 
{ 
echo "<td><hr width='120'><a href='index.php?m=profile&username=$user'><img src='images/noavatar.jpg' height='125px' width='125px' alt='$user' style='border:2px solid #13B1E1;'></img></a><a href='index.php?m=profile&username=$user'>$user</a><br><a href='index.php?m=dellfrend&id=$id'>Премахни от Приятели</a><hr width='120'></td>"; 
} 
else 
{ 
echo "<td><hr width='120'><a href='index.php?m=profile&username=$user'><img src='$picturerow[picture]' height='125px' width='125px' alt='$user' style='border:2px solid #13B1E1;'></img></a><a href='index.php?m=profile&username=$user'>$user</a><br><a href='index.php?m=dellfrend&id=$id'>Премахни от Приятели</a><hr width='120'></td>"; 
} 

if($count == 5) { 
echo '</tr><tr>'; 
} 

} 
} 
echo '</tr></table>'; 
} 
else 
{ 
echo "Няма приятели във вашият списък !"; 
}
?>

 

[KaRo]

<?php
$run_q = mysql_query("SELECT * FROM `users`");
$broi = mysql_num_rows($run_q);
$limit = 10;
if((int)$_GET['page']>0) {
$page = (int)$_GET['page'];
}
else {
$page = 0;
}
$user=$_SESSION['username'];
$db=mysql_query("SELECT * FROM users WHERE username='$user' LIMIT ".($limit*page).", ".$limit."");
while ($r=mysql_fetch_array($db))
{
$id=$r['id'];
}
$sql=mysql_query ("SELECT * FROM frends WHERE uid='$id' LIMIT ".($limit*page).", ".$limit."");
$frends=mysql_num_rows($sql);
if ($frends > 0)
{
echo '<table width="40%"><tr>';
while ($r=mysql_fetch_array($sql))
{
$fid=$r['fid'];
$sql2=mysql_query ("SELECT * FROM users where id='$fid' LIMIT ".($limit*page).", ".$limit."");
while ($r2=mysql_fetch_array($sql2)){
$count++;
$id=$r['id'];
$user=$r2['username'];
$picture=mysql_query("SELECT picture FROM users WHERE username='$user'") or die(mysql_error());
$picturerow=mysql_fetch_array($picture);
// тук и други може да си добавяш
if($picturerow[picture] == NULL)
{
echo "<td><hr width='120'><a href='index.php?m=profile&username=$user'><img src='images/noavatar.jpg' height='125px' width='125px' alt='$user' style='border:2px solid #13B1E1;'></img></a><a href='index.php?m=profile&username=$user'>$user</a><br><a href='index.php?m=dellfrend&id=$id'>Премахни от Приятели</a><hr width='120'></td>";
}
else
{
echo "<td><hr width='120'><a href='index.php?m=profile&username=$user'><img src='$picturerow[picture]' height='125px' width='125px' alt='$user' style='border:2px solid #13B1E1;'></img></a><a href='index.php?m=profile&username=$user'>$user</a><br><a href='index.php?m=dellfrend&id=$id'>Премахни от Приятели</a><hr width='120'></td>";
}

if($count == 5) {
echo '</tr><tr>';
}

}
}
echo '</tr></table>';
}
else
{
echo "Няма приятели във вашият списък !";
}
for($i=0;$i<$maxpage;$i++) {
echo "<a href='?page=$i'> $i | </a>";
}
?>

 

[bankera1990]

нещо не става