Hi Rick,
I tries your code but i'm constantly getting some
errors. I modified the line to try and correct the
error, and this is the code i'm using :
<?php
$db = mysql_connect("localhost","mydb","pwd");
mysql_select_db("mydb",$db);
$query = "LOAD DATA INFILE list.csv INTO list_try
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\n'";
mysql_query($query) or die("error:". mysql_error());
echo "Thank you! Your information has been
entered.\n";
?>
And i'm still getting errors on the mail $query line.
Can you say what is wrong?
T. Edison Jr.
--- Rick Emery <[EMAIL PROTECTED]> wrote:
> connect to your mysql server
> select the mysql database
>
> $query = "LOAD DATA INFILE "datafile.csv" INTO
> mytable ".
> "FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
> '\"' ".
> "LINES TERMINATED BY '\n' ";
>
> mysql_query($query) or die("error:". mysql_error());
>
> -----Original Message-----
> From: Thomas Edison Jr.
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 12, 2002 1:11 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP] Re-Importing .CSV file into
> Database
>
>
> I have space on a server on the internet. I have
> mySQL
> & PHP4 support. And i can easily upload the .CSV
> files
> on the server itself.
> Could you kindly help me out with the php code that
> would make this possible..
>
> Thanks,
> T. Edison jr.
>
> --- Rick Emery <[EMAIL PROTECTED]> wrote:
> > The file is located on the server and you have
> > access to it, yes. If the
> > file is on the client, then no
> >
> > -----Original Message-----
> > From: Thomas Edison Jr.
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, February 12, 2002 12:21 PM
> > To: Rick Emery
> > Subject: RE: [PHP] Re-Importing .CSV file into
> > Database
> >
> >
> > HI,
> >
> > Thanks.. i will try this. But tell me, can this
> same
> > be executed through a php page rather than the
> mySQL
> > command line?
> >
> > T. Edison Jr.
> >
> > --- Rick Emery <[EMAIL PROTECTED]> wrote:
> > > look at MYSQL's LOAD DATA INFILE command:
> > >
> > > LOAD DATA INFILE "datafile.csv" INTO mytable
> > FIELDS
> > > TERMINATED BY ','
> > > OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY
> > '\n'
> > >
> > > -----Original Message-----
> > > From: Thomas Edison Jr.
> > > [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, February 12, 2002 12:02 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: [PHP] Re-Importing .CSV file into
> > Database
> > >
> > >
> > > Glory!
> > >
> > > I have a bunch of .CSV (Microsoft Excel Comma
> > > Seperated Values) Files with me, whose data i
> want
> > > to
> > > put back into my mySQL database tables. How can
> i
> > do
> > > that through php? or otherwise...
> > >
> > > thanks,
> > > 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
>
>
> =====
> 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
