Show product wish-list count in product page in magento

Show product wish-list count in product page in magento:-

Add below line of code in view page:-

app/design/frontend/default/your theme/template/catalog/product/view.phtml

<?php
$resource = Mage::getSingleton('core/resource');
$readConnection = $resource->getConnection('core_read');
$productid = $_product->getId();
$total_wishlist = $readConnection->fetchCol("SELECT count(*) FROM wishlist_item where product_id = '$productid' ");
                                           
echo 'whishlist count:'.$total_wishlist['0'];
?>


You are done!!!