Народ, а может кто для моего скрипта прикрутить постраничный вывод, а то уж никак не доходит принцип работы, привожу код:
<?
mysql_connect("localhost", "guest", "guest");
mysql_select_db("guest");
$query = "select * from news order by id desc";
$result = mysql_query($query) or die (mysql_errno().": ".mysql_error());
$num = mysql_num_rows($result);
if(mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_array($result))
{
$date = $row["date"];
$header = $row["header"];
$id = $row["id"];
$text = $row["text"];
$type = $row["type"];
if ($type == 1) {
$head = "Важная";}
elseif ($type == 2) {
$head = "Обновление";}
else {
$head = "Новость";}
$header = str_replace ( "[r", "<b><font color=red>", $header );
$header = str_replace ( "[g", "<b><font color=green>", $header );
$header = str_replace ( "[", "<u>", $header );
$header = str_replace ( "]", "</b></u><font color=black size=1>", $header );
Echo "
<table width=\\"100%\\" border=\\"0\\" bgcolor=\\"#CACACA\\" cellpadding=\\"2\\">
<tr>
<td bgcolor=\\"#ACACAC\\" class=\\"obvod\\">$date г.</td>
<td width=\\"73%\\" bgcolor=\\"#DFDFDF\\" class=\\"obvod\\"><b>$head:</b> $header</td>
</tr>
<tr>
<td width=\\"9%\\"> </td>
<td colspan=\\"5\\" bgcolor=\\"#DFDFDF\\" class=\\"obvod\\"> $text</td>
</tr>
</table>
";
}
}
?>