На ред по5 снимки?

nom3r1

Registered
Някой може ли да преработи този код и на всеки ред да има по 5 снимките? Тоест аз имам право да кача 10 снимки и от тези 10 снимките на всеки ред да бъдат общо 5 снимки.
Код:
$id = $_SESSION['username'];
    $mysql = mysql_query("SELECT * FROM users WHERE username='$id'");
        echo "
<table cellspacing=\"2\" align=\"center\" width='650'>
    <tr>";
        while($userinfo = mysql_fetch_array($mysql)){
            $userrr = $userinfo['username'];
if ($_SESSION['username'] == $userrr){
    $mysqlA = mysql_query("SELECT * FROM pictures WHERE username='$id'")or die(mysql_error()); 
        while($roww = mysql_fetch_array($mysqlA))
if(mysql_num_rows($mysqlA) > 0){
    $snimka = $roww['snimka'];
    $pic = $roww['id'];
echo "<td><img src=\"$snimka\" width=\"120\" height=\"90\" border=\"0\" onmouseover=\"return overlib('<img src=$snimka width=320 height=240 align=center>');\" onmouseout=\"return nd();\"><br /><br /><a href=\"pic.php?page=delete&id=$pic\">Изтрий</a></td>
<tr>
<td>";
echo "<br />";
    $i++;
}
elseif (mysql_num_rows($mysqlA) < 1 ){
    echo "<td><center>Няма намерени снимки.</center></td>";
}
else{ 
    echo "<td><center>Няма намерени снимки.<br /></center></td>";
} 
if($i > 5){
    echo "</tr><tr>";
    $i = "1";
}
echo "</tr>
</table>
<br />";
}
else {
echo "<center>Това не са вашите снимки!</center>";
}}
 
<?php
$id = $_SESSION['username'];
$mysql = mysql_query("SELECT * FROM users WHERE username='$id'");
echo "
<table cellspacing=\"2\" align=\"center\" width='650'>
<tr>";
while($userinfo = mysql_fetch_array($mysql)){
$userrr = $userinfo['username'];
if ($_SESSION['username'] == $userrr){
$mysqlA = mysql_query("SELECT * FROM pictures WHERE username='$id'")or die(mysql_error());
while($roww = mysql_fetch_array($mysqlA))
if(mysql_num_rows($mysqlA) > 0){
$snimka = $roww['snimka'];
$pic = $roww['id'];
$i = 0;
$i++;
echo "<td><img src=\"$snimka\" width=\"120\" height=\"90\" border=\"0\" onmouseover=\"return overlib('<img src=$snimka width=320 height=240 align=center>');\" onmouseout=\"return nd();\"><br /><br /><a href=\"pic.php?page=delete&id=$pic\">Изтрий</a></td>";
if ($i == 5)
{
$i = 0;
echo "</tr><tr>";
}
}
elseif (mysql_num_rows($mysqlA) < 1 ){
echo "<td><center>Няма намерени снимки.</center></td>";
}
else{
echo "<td><center>Няма намерени снимки.<br /></center></td>";
}
echo "</tr>
</table>
<br />";
}
else {
echo "<center>Това не са вашите снимки!</center>";
}}
?>

Пробвай така.
 
<?php
$id = $_SESSION['username'];
$mysql = mysql_query("SELECT * FROM users WHERE username='$id'");
echo "<table cellspacing=\"2\" align=\"center\" width='650'><tr>";
$userinfo = mysql_fetch_array($mysql);
$userrr = $userinfo['username'];
if ($_SESSION['username'] == $userrr)
{
$mysqlA = mysql_query("SELECT * FROM pictures WHERE username='$id'")or die(mysql_error());
$broika = mysql_num_rows($mysqlA);
if ($broika < 1)
{
echo "<td><center>Няма намерени снимки.</center></td>";
}
else
{
$i = "0";
while($roww = mysql_fetch_array($mysqlA))
{
$snimka = $roww['snimka'];
$pic = $roww['id'];
$i++;
echo "<td><img src=\"$snimka\" width=\"120\" height=\"90\" border=\"0\" onmouseover=\"return overlib('<img src=$snimka width=320 height=240 align=center>');\" onmouseout=\"return nd();\"><br /><br /><a href=\"pic.php?page=delete&id=$pic\">Изтрий</a></td>";
if ($i == "5")
{
$i = "0";
echo "</tr><tr>";
}
echo "</tr>
</table>
<br />";
}
}
}
else
{
echo "<center>Това не са вашите снимки!</center>";
}
?>

Така ?
 

Back
Горе