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
