writing records to text file

[Ian Davies]

I have the following code which displays some some formatted text in my
browser. The problem is I need to create a text file and write the records
from this array into it. Does anyone know how to acheive this.
Thanks in advance
Ian

$query="select * from Questions";
$rt=mysql_query($query);
echo mysql_error();

while($nt=mysql_fetch_array($rt)){
echo "INSERT INTO tQuestions VALUES ("."$nt[QuestionNo]".",
"."$nt[TypeID]".", "."$nt[NCIndex]".", '"."$nt[Question]"."',
'"."$nt[Optiona]"."', '"."$nt[Optionb]"."', '"."$nt[Optionc]"."',
'"."$nt[Optiond]"."', '"."$nt[Optiond]"."', '"."$nt[Optione]"."',
'"."$nt[ImagePath]"."', '"."$nt[answer]"."', '"."$nt[answer2]"."',
'"."$nt[answer3]"."', '". "$nt[answer3]"."', '". "$nt[answer4]"."', '".
"$nt[answer5]"."', '". "$nt[answer6]"."', '". "$nt[answer7]"."', '".
"$nt[answer8]"."', '". "$nt[answer9]"."', '". "$nt[answer10]"."', ".
"$nt[AnsPerQuest]".')<br>';
}

[NC]

Ian Davies wrote:

I have the following code which displays some some formatted
text in my browser. The problem is I need to create a text file
and write the records from this array into it.

Shouldn't be too difficult...

$query = "select * from Questions";
$rt = mysql_query($query)
or die(mysql_error());
$fp = fopen('mydata.txt', 'w')
or die('Could not open the text file for writing');
while ($nt = mysql_fetch_array($rt, MYSQL_NUM)){
$line = "INSERT INTO tQuestions VALUES (" .
implode(',', $nt) .
");\r\n";
fwrite($fp, $line);
}
fclose($fp);

Cheers,
NC

[Ian Davies]

Thanks Nick
Those function were exactly what Ive been searching for but to no avail.
One thing about implode can you limit how many of the fields it returns
I ask because I have modified this
implode(',', $nt)
to
implode("', '", $nt)
because I want quotes around some of the text (as the file will be used to
insert records, mostly text into an mysql table)
However some of the fields are numbers so they do not need quotes so your
original script
implode(',', $nt)
would work

Is there an easy way to do this without lots of code? Doesnt matter if there
isnt as I understand its ok (even desirable) to put numbers in quotes too.

Ian

"NC" <[e-mail]> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Ian Davies wrote:

I have the following code which displays some some formatted
text in my browser. The problem is I need to create a text file
and write the records from this array into it.

Shouldn't be too difficult...

$query = "select * from Questions";
$rt = mysql_query($query)
or die(mysql_error());
$fp = fopen('mydata.txt', 'w')
or die('Could not open the text file for writing');
while ($nt = mysql_fetch_array($rt, MYSQL_NUM)){
$line = "INSERT INTO tQuestions VALUES (" .
implode(',', $nt) .
");\r\n";
fwrite($fp, $line);
}
fclose($fp);

Cheers,
NC

[NC]

Ian Davies wrote:

I want quotes around some of the text (as the file will be
used to insert records, mostly text into an mysql table)
However some of the fields are numbers so they do not need quotes

True, but MySQL won't mind single quotes around numbers...
The problem is, I can't remember if this was always the case
or started effective version 3.23, or started effective
version 4.0... Anyone has memory longer than mine? :)

Cheers,
NC