export mysql data to a text file

[boon_chong]

when i run the code below, there is no text file come out, please help...

[code]<meta http-equiv="refresh" content="5">
<?
include("8_dbconnect.php");
$sql = ("SELECT distinct itemNo,itemDesc,proGroup,saleType,oriPrice,disc,netPrice,
qty,total,date,outlet INTO OUTFILE 'C:/123.txt' FIELDS TERMINATED BY '|' LINES TERMINATED BY '\\r\\n' FROM employee");
$mysql_result = mysql_query($query);

include("8_dbdisconnect.php");
 
?>[/code]

[btherl]

First thing to do is check for errors.  It would also help if you used $sql instead of $query in mysql_query() :)

[code=php:0]$mysql_result = mysql_query($sql) or die("Error in $sql:" . mysql_error());[/code]