How can I write in a loop??
| From: | sunny AT wde | Date: | Fri, 28 Jun 2002 03:23:53 +0000 |
| Subject: | How can I write in a loop?? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-104254@lists.php.net to get a copy of this message | ||
Hi all,
would be very greatful if someone could hlp. Basically I want to
extract information from Mysql, and then write it to a file.
I can write state pieces of text, but having trouble with writing
when the information comes out in a while loop. This is what I hhave
so far:
--------------------
$result=mysql_query("SELECT topicid FROM $topicdb limit 50");
$file_name = "topics.html";
$file_pointer = fopen($file_name, "w");
while ($r = mysql_fetch_array($result)) {
extract($r);
$the_text = "$topicid<br>";
fwrite($file_pointer, $the_text);
";
}
fclose($file_pointer);
print "data written to file successfuly";
----------------------------
but that doesn't seem to work, it only writes the first time, and
doesn't add the rest of the loops. anyone help please?
sunny
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com