Attempting to display is a result of an sql query in PHP:

    FROM wp_celebcount

I am attempting to display two posts: &lifier wp_celebcount.count

Getting trouble obtaining the lead to show with PHP - I wish to show this result on my small index.php Wordpress theme file. Just help...

If you are using Wordpress, it might be something similar to this:

global $wpdb;
$result = $wpdb->get_results('SELECT name, count FROM wp_celebcount');
foreach($result as $row) {
    echo 'Name: '.$row->name.', Count: '.$row->count.'<br/>';

It's suggested to make use of the $wpdb global because it takes proper care of all of the database setup for you personally.

A lot of $wpdb are available here.

Supposing you have done something similar to $resultSet = mysql_query('SELECT * FROM wordpress_celebcount ORDER BY count DESC')

You need to have the ability to take out the outcomes with

while ($row = mysql_fetch_assoc($resultSet))
   //print an element named 'name' with echo $row['name'];