Page 1 of 1

mysql command

Posted: Sun May 06, 2007 7:59 am
by manton
Hi

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());
What am i doing wrong?

thanks in advance :D

Posted: Sun May 06, 2007 8:37 am
by volka
Variable substituion doesn't take place in single-quoted strings.

Code: Select all

$var = 1234;
echo ' a: $var ';
echo " b: $var ";
prints
a: $var b: 1234