Possible Duplicate:
How to show number of new posts in a custom menu item in wordpress admin

I wish to show some notification in wordpress admin menu for brand new posts as possible locate one whenever a new wordpress plugin update can be obtained black circle involves the wordpress plugin menu having a number inside it.

Edit the theme's function.php and append these type of codes -

add_action('admin_menu', 'notification_bubble_in_admin_menu');

function notification_bubble_in_admin_menu() {
    global $menu;
    $newitem = get_number_of_new_post_by_type('post');
    $menu[11][0] .= $newitem ? "<span class='update-plugins count-1'><span class='update-count'>$newitem </span></span>" : '';
}

function get_number_of_new_post_by_type($type)
{
    global $wpdb;
    return $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(*) FROM {$wpdb->prefix}withdraw WHERE wd_status=0;" ) );
}