How to pull a record from the table in MySQL

Try adding the following to the bottom of the plugin file(download-mgr.php):

<?php
function get_download_count($file_name){
global $wpdb;
$dl_count = count($wpdb->get_col("SELECT id FROM $wpdb->downloads WHERE file_name = '$file_name'"));
echo $dl_count;
}
?>


And then, call get_download_count($file_name) at the point where you want the count outputted.

BTW, quick warning: the code is untested and I don’t use Kaf’s plugin but I’ve had a look at the plugin code and it should work.

Actually the code above won’t work. The downloads table is not one WordPress is aware of, hence it’s not available through $wpdb (well, normally).

One option is to reuse some of the *hack* found here:

http://wordpress.org/support/topic/47684

Another is to replace ifelse’s suggestion with the following:

http://guff.szub.net/source/sample-50452.php

<?php get_download_count(); ?>
–This will display a count for all files logged.

<?php get_download_count('file-name.zip'); ?>
–This will display a count for just that file.

<?php $dl_cnt = get_download_count('file-name.zip', false); ?>
–This returns the count, assigning it to the $dl_cnt variable.