Display Custom Fields posts on static page

You’ll want to use something like get_post_custom but review Using_Custom_Fields for a discussion of the topic.

Also might direct you to other possible choices on presenting posts:
https://www.daobydesign.com/blog/2007/07/modifying-wordpress-front-page/
https://weblogtoolscollection.com/archives/2008/04/13/define-your-own-wordpress-loop-using-wp_query/

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

Please place the code you did use in a pastebin and report the link back here. Thanks.

<?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);
  }
?>

but it doesn’t work with the examples mentioned in the codex using_custom_fields

An example of the code you used, that didn’t work, please.