Re: Outputting Data
| From: | John W. Holmes | 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...