mycoolross — Fri, 26 Apr 2002 12:16:16 +0000

Sorry guys

I am using SQL Server 2000

mairving — Fri, 26 Apr 2002 01:13:44 +0000

It might help knowing what DB and Server you are running. Peter gives you the how to in Windows. On a 'nix box using MySQL at the shell, the command would be:

<?php
SELECT * from table
WHERE fieldname='value'
INTO outfile \"/home/username/filename.txt\";
?>

Peter J. Boettcher — Thu, 25 Apr 2002 22:03:23 +0000

If you have access to Extended Stored Procs (xp) you can use xp_cmdshell to gain access to the command line and do whatever you want, or just send control back to the web server and create the file there.