RE: [PHP] Outputting Data
| From: | Jay Blanchard | Date: | Thu, 05 Aug 2004 12:08:25 +0000 |
| Subject: | RE: [PHP] Outputting Data | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-192835@lists.php.net to get a copy of this message | ||
[snip]
I have a query:
$QRY = "SELECT * FROM MembersData";
--> Executes fine, no problems.
I have another though:
$DataSet3 = "SELECT * INTO OUTFILE '/www/Export/DataSet3.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY
'\n'
FROM MembersData";
--> This returns an error saying the query is empty.
Any suggestions people...?
[/snip]
a. This is an SQL question.
b. Use mysql_error() to see if there is an error.
III. Do you have permission to write to /www/Export/ ?
It will send data to the outfile, there will be nothing reurned that you
can work with in PHP.