getting an array (i think) into a text file

[glennn.php]

using fwrite (i can handle that fine) i'm trying to find out how i'd get the results of this query

 

$res = mysql_query("SELECT emails FROM email_list WHERE used != '1' LIMIT ".$limit." ");

while ($row = mysql_fetch_array($res)) {
echo $row['emails']."<br />";
}

 

in such a form as i can then write it to a text file...

 

can someone help me with this, please?

 

much obliged,

gn

 

 

[gizmola]

Just fetch them all into an array then foreach through it and write it to the file.

 

$emails = array();
while ($row = mysql_fetch_assoc($res)) {
  $emails[] = $row['emails'];
}

foreach ($emails as $email) {
  // fwrite your $email
}

[glennn.php]

would this work?

 

$string = $otherstuff;


foreach ($emails as $email) {
$string .= $email;
}

fwrite($fp,$string);

[gizmola]

Yes sure, although you'll have one giant line of emails.  You probably want at least to do:

 

$string .= "$email\n";

[glennn.php]

right, thanks.

 

and you look awfully young to know code this well...

[gizmola]

right, thanks.

 

and you look awfully young to know code this well...

 

I learned php in utero.  I plan to shift 100% to Haskell coding by age 5 though.

[glennn.php]

good enough, you have plenty of time, then.

 

thanks for your help.

[gizmola]

No worries  

 

You can mark topics solved with the button at the bottom if you would like to help us out.