# studiouz (15.11.2016 / 21:54)
Как это сделать?
я выводил так
$req = mysql_query("SELECT `id`, `text`, `soft` FROM `forum` WHERE `type`='f' ORDER BY `realid`");
$i = 0;
while (($res = mysql_fetch_array($req)) !== false) {
echo $i % 2 ? '<div class="list2">' : '<div class="list1">';
$count = mysql_result(mysql_query("SELECT COUNT(*) FROM `forum` WHERE `type`='r' and `refid`='" . $res['id'] . "'"), 0);
////ico/////
echo (file_exists('images/forum_ico/'.$res['id'].'.png') ? '<img src="'.$homeurl.'/images/forum_ico/'.$res['id'].'.png" alt="" align="left" /> ' : '');
//////////////
echo '<a href="forum/index.php?id=' . $res['id'] . '">' . $res['text'] . '</a> [' . $count . ']';
if (!empty($res['soft']))
echo '<div class="sub"><span class="gray"> ' . $res['soft'] . '</span></div>';
echo '</div>';
++$i;
}