Query geeft slechts 1 rij (Opgelost)

$query = 'SELECT * FROM news_topic ORDER BY date DESC, time DESC LIMIT 5';
$result = mysql_query($query);
						
while ($i = mysql_fetch_assoc($result)) {
    echo '<tr>
                <td><img src="images/news/'.$i['cat'].'.bmp" alt="N" /></td>
                <td>'.$i['date'].' - '.$i['time'].'</td>
                <td><a href="news.php?topic='.$i['id'].'">'.$i['subject'].'</a></td>
                <td>';
											
    //aantal replies
    $q = 'SELECT COUNT(*) AS aantal FROM news_reply WHERE topic = "'.$i['id'].'"';
    $r = mysql_query($q);

    while ($j = mysql_fetch_assoc($r)) {
        echo '('.$j['aantal'].' replies)';
    }

    echo '</td></tr>';
}

$query = 'SELECT * FROM news_topic ORDER BY date DESC, time DESC LIMIT 5';
$result = mysql_query($query);
 
while ($i = mysql_fetch_assoc($result)) {
    echo '<tr>
                <td><img src="images/news/'.$i['cat'].'.bmp" alt="N" /></td>
                <td>'.$i['date'].' - '.$i['time'].'</td>
                <td><a href="news.php?topic='.$i['id'].'">'.$i['subject'].'</a></td>
                <td>';
 
    //aantal replies
    $q = 'SELECT COUNT(*) AS aantal FROM news_reply WHERE topic = "'.$i['id'].'"';
    $r = mysql_query($q);
 
    while ($j = mysql_fetch_assoc($r)) {
        echo '('.$j['aantal'].' replies)';
    }
 
    echo '</td></tr>';
}

echo '(' . mysql_result(mysql_query("SELECT COUNT(*) ...") , 0) . ' replies)';

echo '(' . mysql_result(mysql_query("SELECT COUNT(*) ...") , 0) . ' replies)';