Databases
StackOverflow2013
Postsdbo
POTwo WHILE inside a function - Not getting one executed
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTwo WHILE inside a function - Not getting one executed
    primarykey
    data
    text
    <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>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRajeevK
    1. USRajeevK
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POTwo WHILE inside a function - Not getting one executed
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODoes echo $csv_output show the correct result?
      singulars
      1. POTwo WHILE inside a function - Not getting one executed
      1. UScartina
    2. COcan you add var_dump(db_fetch_object($all_paid_scouts_entry)); before entering the while loop? Does it return an array of objects?
      singulars
      1. POTwo WHILE inside a function - Not getting one executed
      1. USthecodeassassin
    3. COI can't tell which database interface you're using here, but many interfaces only keep one resource handle active at a time. So it could be the case that making two `db_query` calls one after the other is essentially throwing one away. Which query is getting added and which is not showing up? Try moving the second `db_query` call after the first while loop.
      singulars
      1. POTwo WHILE inside a function - Not getting one executed
      1. USPatrick M
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload