Hi Dave, This won't have purely SQL only solution , you can use SELECT .. INTO OUTFILE .. syntax to create a file and you can zip the file with a random name and link to that zip file.. This will force the explorer to save the file. If you just let it stay as a text file, the browser won't download it, it will just display, but there might be a way to force the browser download the file by defining a MIME TYPE even if the file is in text format. You may want to make a search on MIME TYPES and see what you come up with.. For the SELECT .. INTO OUTFILE.. syntax, see:
http://www.mysql.com/doc/S/E/SELECT.html Gurhan -----Original Message----- From: Dave [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 07, 2002 7:38 AM To: [EMAIL PROTECTED] Subject: Exporting Data from web page In simple terms I need to be able to click a link on a webpage which runs some SQL to produce a result set and then prompts the user to save this as a pipe delimited file onto their HDD. Or which does the saving to HDD without the prompt but it still needs to be triggered from the webpage. Can't find any info online, in lists or in my MYSQL book. Regards Dave --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
