Am trying to export data from a TABLE named 'registration' to a csv file 'madhu.csv'.
i used the following program to do that:
Code: Select all
<?
include("inc.php"); //contains hostname,username,pwd
$db = mysql_connect($my_server,$my_user,$my_pass) or die("Unable to connect to MySQL");
mysql_select_db($data_base) or die("failed opening database");
$select = "SELECT * INTO OUTFILE 'D:/webserver_files/SV/madhu.csv'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
FROM registration";
$result = mysql_query($select);
?>Please suggest me how to solve this..............
Thanks and regards
MADHU