Hi Christopher
You need the FROM MembersData directly after the SELECT and before outputting.
HTH
Steve
Christopher Chamber wrote:
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...?
----------------------- Christopher Chamber http://gem-hs.org/cc.html
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]