Good day, The proper syntax is:
INTO TABLE <table> and not: INTO <table> ============================ Darren Gamble Planner, Regional Services Shaw Cablesystems GP 630 - 3rd Avenue SW Calgary, Alberta, Canada T2P 4L4 (403) 781-4948 -----Original Message----- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 9:54 AM To: Jason Murray Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Re-Importing .CSV file into Database Hi, Ok, considering the FULL PATH and the QUOTES thingy, this is the code i'm applying : <?php $db = mysql_connect("localhost","mydb","pwd"); mysql_select_db("mydb",$db); $query = "LOAD DATA INFILE 'D:\Apache Group\Apache\htdocs\mjimm\php3\tabledata\fanlist.csv' INTO fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n' "; mysql_query($query) or die("error:". mysql_error()); ?> And this is the error i'm getting : error:You have an error in your SQL syntax near 'fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED' at line 1 So... what's the problem?? Thanks guys, though. T. Edison jr. ===== Rahul S. Johari (Director) ****************************************** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 ******************************************* __________________________________________________ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
