latest posts

    <ul class="blocks-holder">
<?php
    $query="SELECT post_author, post_title, post_content FROM wp_posts WHERE post_status='publish' AND post_type='post'";
    $res=mysql_query($query);

    if($res && mysql_num_rows($res)>0){
        while($row=mysql_fetch_assoc($res)){
        $id=$row['id']."";
        $title=$row['post_title']."";
        $date=$row['post_date']."";
        $firstimg=$row['post_firstimg']."";
        ?>
        <li class="block">
            <div class="block-ribbon">
                <div class="left">
                    <div class="block-title"><a href='blog/?p=<?php echo $id; ?>'><?php echo $title; ?></a></div>
                    <div class="block-date"><?php echo $date; ?></div>
                </div>
                <div class="right"></div>
            </div>
            <a href='blog/?p=<?php echo $id; ?>'><img src='<?php echo $firstimg; ?>' alt="Thumb" class="thumb" title="Thumbnail" width="300" height="157" /></a>
        </li>
        <?php }
    } else {
        echo "Nessun Articolo";
    }
?>
</ul>