Mssql Help

[trebian]

Hello folks. I am hoping to find some help on the MSSQL related issue I have. I need to find out how to -within sql script-have the results from the select statement to go into a text file?

For example: If I have:
select * from table A ;

how and what can I add to this to have the std output go to a text file.

Much thanks,

Tre

[kevinsequeira]

$query = "select id from tableA";
$result = mysql_query($query);
$fp = @fopen("file.txt","w");
if ($fp) {
print "The file exists!";
} else {
print "The file does not exist";
while($row = mysql_fetch_array($result)){
fputs($fp,"$row['id']\r\n");
}
fclose();
}
mysql_close($fp);

reg
kevin

[trebian]

Thank you for your answer. Just want to ensure that the help I sought was for within MSSQL DB. I am not doing anything web related!

Tre