[support] Printing "0" when a db query returns nothing

[Neil Coghlan]

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 at 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 at vailtech.net

  (510) 444-5380


------------------------------------------------------------------------------

  From: Neil Coghlan [mailto:neil at esl-lounge.com] 
  Sent: Friday, April 09, 2010 9:50 AM
  To: support at 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/ ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20100409/8333441e/attachment-0001.html