mysql command
Posted: Sun May 06, 2007 7:59 am
Hi
I want to use a variable inside to a sql query, here is an example
What am i doing wrong?
thanks in advance
I want to use a variable inside to a sql query, here is an example
Code: Select all
$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());thanks in advance