title: Two WHILE inside a function - Not getting one executed
body: <p>I am trying to add the result of two DB_QUERY inside a function one after one by help of WHILE, but getting result one only one WHILE when I am downloading CSV, where I am printing the final variable. Here is the code -</p>
  
  <pre><code>    &lt;?php
  
  function getPaidScoutUsers($nid) {
    $csv_output = '';
    $all_paid_scouts_entry = db_query("SELECT * FROM {signup_event} WHERE event_nid = %d",$nid);
    while($paid_user = db_fetch_object($all_paid_scouts_entry)){
      $role_name     = 'Scout';
      $profile       = content_profile_load(scout_profile, $paid_user-&gt;attendee_uid);
      $firstname     = $profile-&gt;field_sfname[0]['value'];
      $lname         = $profile-&gt;field_last_name[0]['value'];
      $patrol        = get_term_name($profile-&gt;field_scout_patrol[0]['value']);
      $position      = get_term_name($profile-&gt;field_scout_rank[0]['value']);    
      $homephone     = "";
      $cellphone     = "";
      $email         = "";
      $paid_status   = 'Paid';
      $payment_date  = date_format_date($paid_user-&gt;created_date[0]['value'],$type = 'custom', $format = 'm/d/Y');
      $csv_output .= "\"".$role_name."\"".","."\"".$lname ."\"".","."\"".$firstname."\"".","."\"".$patrol."\"".","."\"".$position."\"".","."\"".$homephone."\"".",".$cellphone.",".$email.","."\"".$paid_status."\"".","."\"".$payment_date."\""."\r";    
    }
    return $csv_output;
  }
  
  function getUnpaidUsers($nid) {
      $csv_output = '';
      $all_unpaid_scout_list = db_query("SELECT * FROM users
                                       INNER JOIN users_roles ON users.uid = users_roles.uid
                                       WHERE users_roles.rid =7
                                       AND users.uid NOT IN (
                                       SELECT attendee_uid FROM signup_event WHERE event_nid = %d)
                                       ORDER BY name ASC",$nid);
      while($unpaid_user = db_fetch_object($all_unpaid_scout_list)){
        $role_name     = 'Scout';
        $profile       = content_profile_load(scout_profile, $unpaid_user-&gt;uid);
        $firstname     = $profile-&gt;field_sfname[0]['value'];
        $lname         = $profile-&gt;field_last_name[0]['value'];
        $patrol        = get_term_name($profile-&gt;field_scout_patrol[0]['value']);
        $position      = get_term_name($profile-&gt;field_scout_rank[0]['value']);   
        $homephone     = trim($profile-&gt;home_phone[0]['value']);
        $cellphone     = trim($profile-&gt;cell_phone[0]['value']);
        $email         = $profile-&gt;email_1;
        $paid_status   = 'Unpaid';
        $payment_date  = '';
        $csv_output .= "\"".$role_name."\"".","."\"".$lname ."\"".","."\"".$firstname."\"".","."\"".$patrol."\"".","."\"".$position."\"".","."\"".$homephone."\"".",".$cellphone.",".$email.","."\"".$paid_status."\"".","."\"".$payment_date."\""."\r";
      }
      return $csv_output;
  }
  
  function event_signup_download_detail($nid)
  { 
      //global $user;   
      module_load_include('inc', 'signup_event', 'event_signup_view');
      $csv_output = '';
      $csv_output .= "Role,Last name,First Name,Patrol,Position,Home phone,Cell Phone,Email,Payment Status,Payment Date\n";           
      $nid = 2001;
  
      // add the paid users to the csv 
      $csv_output .= getPaidScoutUsers($nid);
  
      // get unpaid users, add them to the csv
      //$csv_output .= getUnpaidUsers($nid);
  
      echo $csv_output;
  
      header("Content-type: application/vnd.ms-excel");
      header("Content-Disposition: attachment;   filename=\"Registration_Dues_Information.csv\"");
      print $csv_output;
      exit; 
  
  }
  </code></pre>
  
  <p>Where I am wrong in this ? Can anybody help ?</p>