Re: Outputting Data

From: Date: Thu, 05 Aug 2004 14:11:14 +0000
Subject: Re: Outputting Data
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-192862@lists.php.net to get a copy of this message
> 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...? How are you executing the query? What line or function is giving you this error? Normally when you see this error, it's because you did something like mysql_query($dataset3) instead of mysql_query($DataSet3) or basically sent, get this, an empty query. :) ---John Holmes...

« previous php.general (#192862) next »