Sql command

manton

I want to use a variable in sql command like

$var = $_SERVER['DOCUMENT_ROOT']."/files/data.csv";
$sql = 'LOAD DATA LOCAL INFILE \"'$var'\" INTO TABLE `data` FIELDS TERMINATED BY \';\' ENCLOSED BY \'"\' ESCAPED BY \'\\\\\' LINES TERMINATED BY \'\\r\\n\'';
mysql_query($sql, $palso) or die(mysql_error());

What am i doing wrong?

Thanks in advanced

tomhath

Start out with double quotes so the $ variable is evaluated. Then you don't need to escape the single quotes inside (not well tested):

$sql = "LOAD DATA LOCAL INFILE '$var' INTO TABLE data FIELDS TERMINATED BY ';'" .
       " ENCLOSED BY  '\"' ESCAPED BY '\\' LINES TERMINATED BY '\\r\\n' ";