Thomas, Can you provide your table structure and about a dozen lines from your file?
I'd like to experiment with it on my machine. We WILL get this resolved... rick -----Original Message----- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:09 AM To: Rick Emery Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Re-Importing .CSV file into Database Oh yes, definately. With the appropriate columns too. --- Rick Emery <[EMAIL PROTECTED]> wrote: > Has fanlist_try table been created? > > -----Original Message----- > From: Thomas Edison Jr. > [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 13, 2002 10: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 > ===== 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
