Просмотр поста

REALball, Я вытаскиваю авторов из библиотеки.
Вот что у меня на первой странице.

$str = mysql_query("SELECT COUNT(*) FROM lib WHERE type ='bk' GROUP BY avtor"); 
$total = mysql_result($str, 0); 
$str=mysql_query("SELECT * FROM lib WHERE type='bk' GROUP BY avtor"); 
while($row = mysql_fetch_array($str)) 
{ 
echo '<div class="list1"><a href="../tester/stih.php?avtor=' .$row['avtor']. '">' . $row['avtor'] . '</a></div>'; 
} 
echo '<div class="phdr">Всего: ' . $total . '</div>'; 
if ($total > $kmess) { 
echo '<div class="topmenu">' . 
functions::display_pagination('index.php?avtor=' . $avtor . '&amp;', $start, $total, $kmess) . '</div>' . 
'<p><form action="stih.php" method="get"><input type="hidden" name="id" value="' . $id . '"/><input type="text" name="page" size="2"/><input type="submit" value="' . $lng['to_page'] . ' &gt;&gt;"/></form></p>'; 
}

$total = mysql_num_rows("SELECT * FROM `lib` WHERE avtor='graver' and moder=1"); 
$str=mysql_query("SELECT * FROM `lib` WHERE type='bk' AND avtor='" . mysql_real_escape_string($_GET['avtor']) . "' LIMIT $start, $kmess"); 
while($row = mysql_fetch_array($str)) 
{ 
echo '<div class="list1"><a href="../library/index.php?id=' .$row['id']. '">' . $row['name'] . '</a></div>'; 
} 
echo '<div class="phdr">' . $lng['total'] . ': ' . $total . '</div>'; 
if ($total > $kmess) { 
echo '<div class="topmenu">' . 
functions::display_pagination('stih.php?id=' . $id . '&amp;', $start, $total, $kmess) . '</div>' . 
'<p><form action="stih.php" method="get"><input type="hidden" name="id" value="' . $id . '"/><input type="text" name="page" size="2"/><input type="submit" value="' . $lng['to_page'] . ' &gt;&gt;"/></form></p>'; 
}