<?php

global $wpdb, $post;

// How many links do you want to make
$c=3;



$post_id = $post->ID;
$post_count = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE ID > '$post_id' AND post_type = 'post' AND post_status = 'publish'");

if ($post_count >= $c)
{
$posts = $wpdb->get_results("SELECT ID, guid, post_title FROM $wpdb->posts WHERE ID > '$post_id' AND post_type = 'post' AND post_status = 'publish' LIMIT 10");
}
else
{
$posts = $wpdb->get_results("SELECT ID, guid, post_title FROM $wpdb->posts WHERE ID > '$post_id' AND post_type = 'post' AND post_status = 'publish' LIMIT 10");


$limit = $c - $post_count;
$posts = array_merge($posts, $wpdb->get_results("SELECT ID, guid, post_title FROM $wpdb->posts WHERE ID > 0 AND post_type = 'post' AND post_status = 'publish' LIMIT $limit"));
}



// Print links-block

for ($i = 0; $i < $c; $i++)
{

$object = $posts[$i];


// getting seo-title (to use instead of post header)

$ppp = $object->ID;

if ($ppp > 0)
{
$purl = $object->guid;
$pheader = $object->post_title;
$ptitle= $wpdb->get_var("SELECT meta_value FROM `wp_postmeta` WHERE meta_key = 'title_tag' AND post_id = $ppp");
if ($ptitle =="") { $ptitle=$pheader;}
echo "\r\n\r\n<a href=\"$purl\" title='$pheader'>\r\n$ptitle</a> &nbsp;&nbsp;&nbsp;| ";
}

}

?>