Display Custom Fields posts on static page

Sorry Michael but I don’t see the connection between my problem and your links. I’ve already the titles of the posts now I also want to display the value of a custom field but it doesn’t work with the examples mentioned in the codex using_custom_fields

<?php
  # Here starts Mini Loop trick: You can use this code, but _at your own risk_
  # If you want to improve this code, you're welcome ;)
  $how_many=8; //How many posts do you want to show
?>
<ul id="news">
<?php
  $news=$wpdb->get_results("SELECT ID,post_title FROM $wpdb->posts
    WHERE <code>post_type</code>=\"post\" AND <code>post_status</code>= \"publish\" ORDER BY <code>post_date</code> DESC LIMIT $how_many");
  foreach($news as $np){
    printf ("<li><a href=\"index.php?p=%s\">%s</a></li>", $np->ID,$np->post_title);
  }
?>