RE: [PHP] How can I write in a loop??

[sunny AT wde]

my bad. I edited to strip out some of the html and left that in there
by mistake.

the code works as i said, but only to write the first time ti loops,
and doesn't add in anything after. 

sunny

--- Martin Towell [EMAIL PROTECTED] wrote:
 Is this a direct copy of what you've got? If so, line 11 shouldn't
 be there
 
 -Original Message-
 From: sunny AT wde [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 28, 2002 1:24 PM
 To: [EMAIL PROTECTED]
 Subject: [PHP] How can I write in a loop??
 
 
 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 = $topicidbr;  
  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 
 
 
 
 -- 
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 


__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] How can I write in a loop??

[Jason Wong]

On Friday 28 June 2002 17:31, sunny AT wde wrote:
 my bad. I edited to strip out some of the html and left that in there
 by mistake.

 the code works as i said, but only to write the first time ti loops,
 and doesn't add in anything after.

I would suggest posting your full code. Unless it's very large. In which case 
you should debug by starting with a simple loop. get it working, then build 
on it:

  while ($r = mysql_fetch_array($result)) {
print_r($r);
  }

-- 
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *

/*
As flies to wanton boys are we to the gods; they kill us for their sport.
-- Shakespeare, King Lear
*/


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] How can I write in a loop??

[Martin Towell]

Is this a direct copy of what you've got? If so, line 11 shouldn't be there

-Original Message-
From: sunny AT wde [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 28, 2002 1:24 PM
To: [EMAIL PROTECTED]
Subject: [PHP] How can I write in a loop??


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 = $topicidbr;
 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 



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php