Hi Rick, Thanks for the support! This is the mySQL Table Structure :
$sql = "CREATE table fanlist_try (ID bigint(21) NOT NULL auto_increment, name varchar(50), email varchar(70), age int(10), sex varchar(20), country varchar(50), PRIMARY KEY (ID))"; And these are few lines from the fanlist.csv file : 1;"Akshay Dodeja";"[EMAIL PROTECTED]";"16";"Male";"United States" 2;"PAUL MEADOWS";;"23";"Male";"United Kingdom" 3;"shefalee";"[EMAIL PROTECTED]";"15";"Female";"India" 4;"femke dees";"[EMAIL PROTECTED]";"14";"Female";"Netherlands" 5;"bram dees";"[EMAIL PROTECTED]";"48";"Male";"Netherlands" In fact, i'm attaching a portion of the .csv file i'm using... Thanks, T. Edison jr. --- Rick Emery <[EMAIL PROTECTED]> wrote: > 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 > ===== 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
