Did you ever want to display how many blogroll links you have in total? If yes, just read this recipe. It’s pretty easy to do using the $wpdb object and some SQL.
Simply paste the following code where you want the count to be displayed:
<?php $numlinks = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->links WHERE link_visible = 'Y'"); if (0 < $numlinks) $numlinks = number_format($numlinks); echo $numlinks; ?>
Thanks to Jeff Starr for this tip!