[php:1:f002dd67e6]<?php
sbs();
polacz();
if (!isset($sn))
{$sn=0;}
if ($zalogowany=="0") {$jezyk="polish";}
else
{
$sql="SELECT id,jezyk,up_forum FROM users WHERE nick='$zalogowany'";
$res=mysql_query($sql);
$rek=mysql_fetch_array($res);
$jezyk=$rek['jezyk'];
$upraw=$rek['up_forum'];
}

if ($upraw=="0" OR $upraw=="1")
{echo '<p class="tekst"><font color="maroon"><center><br><br> <b> You do not have rights to access this forum.
</b></font></center>';
}

else
{

if ($zalogowany=="0" OR !isset($zalogowany) OR $zalogowany=="")
{
echo '<p class="tekst"><font color="maroon"><center><br><br> <b> You have to be logged in to view&write on forums.</b></font></center>';
}

echo'
<table border="0" cellpadding="0" cellspacing="0" width="90%" align="center">
<tr>
<td colspan="3" width="100%" height="25"><p class="tytul"><a href="./?akcja=newpostarcy&odpowiedz=0">new post</a> | <a href="./?akcja=forum">back to main forum</a><br><br></td></tr>
<tr>
<td width="70%" height="25"><p class="tytul">Title</td><td height="25" width="10%"><p class="tytul">Posts</td><td width="20%"><p class="tytul">Posted by</td>
';

$sqler="SELECT id FROM forumarcy";
$reser=mysql_query($sqler);

$sql="SELECT * FROM forumarcy WHERE odpowiedz=0 ORDER by data desc LIMIT $sn, 30";
$res=mysql_query($sql);
$i=0;
$il_wp=mysql_num_rows($res);
while($rek=mysql_fetch_array($res))
{

$closed=$rek['priorytet'];
$data=$rek['data'];
datownik($data);
$rek['tresc'] = ereg_replace("n", "<br>", $rek['tresc']);
$rek['tresc'] = znajdz_linki($rek['tresc']);
flags();

$id= $rek['id'];
$bsql="SELECT id FROM forumarcy WHERE odpowiedz=$id";
$bres=mysql_query($bsql);
$brek=mysql_fetch_array($bres);
$il_pos=mysql_num_rows($bres);

$autor=$rek['autor'];
$sq="SELECT id,jezyk FROM users WHERE nick='$autor'";
$red=mysql_query($sq);
$rem=mysql_fetch_array($red);
$pid=$rem['id'];

rozlacz();
echo
'
<tr>
<td width="70%" height="20" valign="middle"><p class="tytulek"><a href="./index.php?akcja=viewpostarcy&id='.$rek['id'].'">'.$rek['tytul'];
if ($closed=="Bclosed") {echo' [topic closed]';} else{}
echo'</a></td>
<td width="10%" height="20" valign="middle"><p class="tytulek">'.$il_pos.'</td>
<td width="20%" height="20" valign="middle"><p class="tytulek"><a class="inny" href="index.php?akcja=view_profile&id='.$pid.'">'.$rek['autor'].'</a>
</tr>
';

}
echo '</table>';

echo'
<table border="0" cellpadding="0" cellspacing="0" width="98%">
<tr>';

$dsn=$sn+30;
$osn=$sn-30;

if ($dsn>$il_wp AND $sn==0)
{}
elseif ($dsn>$il_wp)
{
echo'<td width="50%"><p align="center"><a class="nawigator" href="./?akcja=forumarcy&sn='.$osn.'">&laquo;- newer postss</a></td>
<td width="50%"></td>';
}
elseif ($dsn<=$il_wp AND $sn==0)
{
echo'<td width="50%"></td>
<td width="50%"><p align="center"><a class="nawigator" href="./?akcja=forumarcy&sn='.$dsn.'">older posts -&raquo;</a>
</td>';
}
elseif ($dsn<=$il_wp)
{
echo'<td width="50%"><p align="center"><a class="nawigator" href="./?akcja=forumarcy&sn=='.$osn.'">&laquo;- newer posts</a></td>
<td width="50%"><p align="center"><a class="nawigator" href="./?akcja=forumarcy&sn='.$dsn.'">older posts -&raquo;</a>
</td>';
}
echo'
</table></div></td>';

}
?>
</td>
[/php:1:f002dd67e6]

[sql:1:f002dd67e6]CREATE TABLE forumpublic ( ".
"id int(11) DEFAULT '0' NOT NULL auto_increment, " .
"data timestamp(14), ".
"autor tinytext NOT NULL, ".
"tytul tinytext NOT NULL, ".
"tresc text NOT NULL, ".
"odpowiedz text NOT NULL, ".
"priorytet tinytext NOT NULL, ".
"PRIMARY KEY (id), ".
"UNIQUE id (id)" .
[/sql:1:f002dd67e6]

Taki kod dostalem od kumpla. ma nastepujacy problem:

[sql:1:35e3883fc5]... WHERE odpowiedz=0 ORDER BY id DESC[/sql:1:35e3883fc5]