Просмотр поста #62699: >>>ВОПРОСЫ НОВИЧКОВ<<<

<?php

define('_IN_JOHNCMS', 1);

require_once ("../incfiles/func.php");
require_once ("../incfiles/core.php");
require_once ("../incfiles/head.php");

switch ($act) {
case 'all':

		$req = mysql_query("SELECT * FROM `recenzies` ORDER BY `id` DESC LIMIT " . $start . "," . $kmess . ";") or die ("Could not query: ". mysql_error());

echo "<table border><tr>";
echo "<td>Исполнитель</td><td>Жанр</td><td>Альбом</td><td>Год</td><td>Трэклист</td><td>Оценка</td><td>Рецензия</td>
</tr>";
for ($c=0; $c<mysql_num_rows($req); $c=$c+1) 
{
$text=mysql_fetch_array($req);
echo "<tr><td>".$text['artist']."</td>";
echo "<td>".$text['gengre']."</td>";
echo "<td>".$text['album'].'</td>';
echo "<td>".$text['year']."</td>";
echo "<td>".$text['tracklist']."</td>";
echo "<td>".$text['rated']."</td>";
echo "<td>".$text['text']."</td></tr><br/>";
}
echo "</table>";
        $req = mysql_query("SELECT COUNT(*) FROM `recenzies`");
        $total = mysql_result($req, 0);
			if ($total > $kmess) {
				echo '<p>' . pagenav('read.php?act=all&', $start, $total, $kmess) . '</p>';
				echo '<p><form action="index.php" method="get"><input type="hidden" name="act" value="new"/><input type="text" name="page" size="2"/><input type="submit" value="К странице &gt;&gt;"/></form></p>';
			}
			
	echo '<div class="">Всего рецензий: '.$total.'</div>';
	echo '<a href="read.php">Назад</a>';
		
break;
default:
echo '<a href="read.php?act=all">рецензии</a></div>';
echo '<a href="index.php">Управление</a>';
break;	
}
require_once ("../incfiles/end.php");

?>