I am using the following code on a windows system
<?php
$db_name = "updater";
$table_name = "logs";
$connection = mysql_connect("xxxx","xxx", "xxx") or die("Couldn't connect.");
$db = mysql_select_db($db_name, $connection)or die("Couldn't select database.");
$sql = "SELECT * INTO OUTFILE 'c:/phpweb/updater/users.txt' FROM logs";
$result = mysql_query($sql,$connection)or die("sql invalid");
?>
The script does not seem to recognise the path to the users.txt. Do i have to create the file before i run the script or will it automatically be created and am i referencing the path correctly ?
Thanks in advance.