hi,
I am trying to upload a file the client and upload to the server . After upload I use "LOAD DATA INFILE...". The upload happens fine but mysql always complains that the file is not found...
here is my code
include("../dbconnect.php");
$upload_dir='http://localhost/parent/child/subchild/';
$uploadfile = $uploaddir . $_FILES['userfile']['name'];
move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile);
$sql="LOAD DATA INFILE '".$upload_dir.$uploadfile."' into table temp_camp";
echo $sql;
$rs=query_db($sql)or die(mysql_error())
the output is
any suggestions???