sorry for my fault: I forgot $ (dollar sign) before sql variable.
Sommai
At 09:58 28/2/2002 +0700, Sommai Fongnamthip wrote:
>Hi,
> Please tell me why this mysql in php error:
>
>sql = "LOAD DATA LOCAL INFILE \"/home/httpds/htdocs/srg/data/tct.csv\"
>INTO TABLE tct_temp FIELDS TERMINATED BY '\|'";
>$result = mysql_db_query("$dbName", $sql)
> or die ("Can not run: $sql");
>
> I try another sql style like these
>sql = "LOAD DATA LOCAL INFILE '/home/httpds/htdocs/srg/data/tct.csv' INTO
>TABLE tct_temp FIELDS TERMINATED BY '\|'";
>
>sql = "LOAD DATA LOCAL INFILE 'data/tct.csv' INTO TABLE tct_temp FIELDS
>TERMINATED BY '\|'";
>
>
>Thanks
>Sommai
>
>----------------------------------------------------------
>Please be informed that all e-mail which are addressing to
>thaithanakit.co.th will need to be changed to
>BTsecurities.com by March 1, 2002 Thank you. :-)
>----------------------------------------------------------
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
----------------------------------------------------------
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities.com by March 1, 2002 Thank you. :-)
----------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
