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

$q=mysql_query("SELECT * FROM `microblogs` ORDER BY `time` DESC LIMIT 5");
$req=mysql_query("SELECT COUNT(*) FROM `microblogs`;");
$total=mysql_result($req, 0);
echo '<div class="phdr">ВЫВОД ПОСЛЕДНИХ  5 ЗАПИСАЕЙ с микроблока</div>';
while ($mb=mysql_fetch_array($q))
{
$name=mysql_fetch_array(mysql_query("SELECT `name` FROM `users` WHERE `id`='" . $mb['user_id'] . "';"));
echo ceil(ceil($i / 2) - ($i / 2)) == 0 ? '<div class="list1">' : '<div class="list2">';
if ($user_id!=$mb['user_id'])
echo '<a href="users/profile.php?user=' . $mb['user_id'] . '">' . $name['name'] . '</a> <font color="#777777">(' . date("d.m.Y / H:i", $mb['time']) . ')</font><br/>';
if ($user_id==$mb['user_id'])
echo '<b>' . $name['name'] . '</b> <font color="#777777">(' . date("d.m.Y / H:i", $mb['time']) . ')</font><br/>';
echo $mb['message'] . '<br/>';
$req_n=mysql_query("SELECT COUNT(*) FROM `mb_new` WHERE `blog_id`='" . $mb['blog_id'] . "' AND user_id='" . $user_id . "' ;");

$num_k=mysql_num_rows(mysql_query("SELECT * FROM `mb_komm` WHERE `blog_id`='" . $mb['blog_id'] . "';"));
echo '<a href="users/profile.php?user=' . $mb['user_id'] . '&amp;komm=1&amp;mb=' . $mb['blog_id'] . '"><small>Комментарии (' . $num_k . ')</small></a>';
echo '</div>';
$i++;
}
if ($total == 0)
{
echo 'Новых записей нет!<br/>';
}