on 10/26/04 3:16 PM, Christopher Chamber at [EMAIL PROTECTED] 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...?
I think you need to put the FOMR MembersData after the *, so $DataSet3 = "SELECT * FROM MembersData INTO OUTFILE etc etc -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Fax: 313.557.5052 <[EMAIL PROTECTED]> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
