that's worked fine for those members with 0 downloads, but for example, someone with 5 is now showing 50. ----- Original Message ----- From: Warren Vail To: support@drupal.org Sent: Friday, April 09, 2010 2:03 PM Subject: Re: [support] Printing "0" when a db query returns nothing Echo sprintf("%01d", $count); Warren Vail Vail Systems Technology warren@vailtech.net (510) 444-5380 ------------------------------------------------------------------------------ From: Neil Coghlan [mailto:neil@esl-lounge.com] Sent: Friday, April 09, 2010 9:50 AM To: support@drupal.org Subject: [support] Printing "0" when a db query returns nothing I am trying to print the number of downloads a user's attachments have produced and am 95% there. I just don't know how to print zero if the SUM returns nothing. here's what I have so far (with download count module installed which creates file_downloads table) <?php $query= "SELECT SUM(count) AS DownloadCount FROM upload JOIN files ON upload.fid = files.fid JOIN file_downloads ON files.filepath = CONCAT( 'sites/default/files/', file_downloads.filename ) WHERE (files.uid = $account->uid)"; $results = db_query($query); while($output = db_fetch_object($results)){ print $output->DownloadCount; } ?> works perfectly for those whose content have created downloads. For those who haven't, the result is a blank space. How can I print a nice fat "0"?? regards Neil ------------------------------------------------------------------------------ -- [ Drupal support list | http://lists.drupal.org/ ]