I tried doing the same procedure on this post :Wordpress Titles: If Longer Than 50 Characters, Show Ellipsis
but no luck at all , can you tell what did i do wrong?
here's my snippet
function wpfp_list_most_favorited($limit=5) {
global $wpdb;
$query = "SELECT post_id, meta_value, post_status FROM $wpdb->postmeta";
$query .= " LEFT JOIN $wpdb->posts ON post_id=$wpdb->posts.ID";
$query .= " WHERE post_status='publish' AND meta_key='".WPFP_META_KEY."' AND meta_value > 0 ORDER BY ROUND(meta_value) DESC LIMIT 0, $limit";
$results = $wpdb->get_results($query);
if ($results) {
echo "<ul>";
foreach ($results as $o):
$p = get_post($o->post_id);
$post = mb_strimwidth($p, 0, 20, '...');
echo "<li>";
echo "<a href='".get_permalink($o->post_id)."' title='". $p->post_title ."'>" . $post->post_id . "</a> ($o->meta_value)";
echo "</li>";
endforeach;
echo "</ul>";
}
}