Forum php

<?php
$dn2 = mysql_query('select t.id, t.title, t.authorid, u.username as author, count(r.id) as replies from topics as t left join topics as r on r.parent="'.$id.'" and r.id=t.id and r.id2!=1  left join users on id=t.authorid where t.parent="'.$id.'" and t.id2=1 group by t.id order by t.timestamp2 desc');
if(mysql_num_rows($dn2)>0){;
while($dnn2 = mysql_fetch_array($dn2)){;?>  
      <div><img style="float: left;" src="http://icons.iconarchive.com/icons/chrisl21/minecraft/32/Diamond-Sword-icon.png"></div>
      <a href="detail.php?id=<?php echo $dnn2['id']; ?>" style="color:green"><b style="font-size: 16px; margin-left: 10px;"><?php echo htmlentities($dnn2['title'], ENT_QUOTES, 'UTF-8'); ?></b></a>
      <div class="text" style="margin-left: 43px;"><b>Autor</b>: <?php echo htmlentities($dnn2['author'], ENT_QUOTES, 'UTF-8'); ?> | <b>Odpovědí</b>: <?php echo $dnn2['replies']; ?></div>
<?php };}else{?><div class="message">V kategorii nejsou žádná témata!</div><?php };?>
<?php }else{echo '<h2>Tato kategorie neexistuje!</h2>';}}else{echo '<h2>Kategorie kterou hledáte nebyla nalezena!</h2>';}?>