using fputs

[nca]

while ($a3 = mysql_fetch_array ($a2)) {
	if ($a3[0] != "0") {
	$file = fopen("file.txt", "w");
	fputs($file, "$a3[0]");
	fclose($file);
	}
}

When using this code, the file.txt is only left with the last entry. It must erase the file.txt every time fputs is executed. How can I make it so that it does not keep overwriting the whole file?

[ahundiak]

Move the fopen/fclose to outside of the while loop.
It's fopen which is deleting the previous contents.

You could also open the file for append (see the manual on fopen options) but there is really no need to be constantly opening and closing the file.

[juschillinnow]

use this

$file = fopen("file.txt", "a+");

instead of

$file = fopen("file.txt", "w");

if it has to be done like this....otherwise do what the guy above said

[nca]

THANK YOU! 😃