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

<?php
$tema=mysql_query("SELECT * FROM `pod` WHERE `user_id` = '$user_id' ORDER BY `topik_id`");

while($row=mysql_fetch_assoc($tema)){
$topic = mysql_fetch_array(mysql_query("SELECT * FROM `forum` WHERE `id` = '$row[topic_id]' LIMIT 1"));
$post = mysql_fetch_array(mysql_query("SELECT * FROM `forum` WHERE `refid` = '$topic[id]' ORDER BY `time` DESC LIMIT 1"));
echo '<div class="tmn"><a href="index.php?id='.$row['topik_id'].'">'.$topic['id'].'</a><div class="sub">'.$post['from'].'
' <span class="gray">(' . functions::display_date($post['time']) . ')</span></div>
</div>';
};
?>