vis alle poster i databasen

Hej...

er der ikke lige nogen der kan hjælpe mig med at få nedenstående script-ting, til at udskrive alle poster fra min MySQL-db?

..:: script ::..

<?php
        include "config.php";
    $fejl = '';
    $query1 = "SELECT date, author_id, title, comment FROM sap_news ORDER by id desc";
    $result = mysql_query($query1) or die("MySQL fejl: " . mysql_error());
    $log = mysql_fetch_array($result);

    $query2 = "SELECT nick FROM sap_member WHERE id= '".$log['author_id']."'";
    $res = mysql_query($query2) or die("MySQL fejl: " . mysql_error());
        $writer = mysql_fetch_array($res);

?>
<span class="headline"><?php echo($log['title']); ?></span><br />
<span class="con">by <?php echo($writer['nick']); ?><?php echo date( " d/m Y", $log['date'] ); ?></span><br /><br />
<?php echo($log['comment']); ?>