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 ','
DL Neil,
OK buddy, let me be more than frank with you.. i don't
think i've been quite as confused and having the
expression what the hell are you tryin 2 say on my
lips in a while, as i had when i read your mail.
Hmm.. i do hope u can help me though..
T. Edison jr.
Further to David's
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
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
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
:[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
: 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
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));
sex varchar(20) sounds great. why do
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
Val,
quite frankly, i'm not quite sure i know what you're
talking about. i don't think i know enum() function!!
T. Edison jr.
--- val petruchek [EMAIL PROTECTED] wrote:
Hi Rick,
Thanks for the support!
This is the mySQL Table Structure :
$sql = CREATE table fanlist_try (ID
-
From: Thomas Edison Jr. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 13, 2002 7:36 PM
Subject: Re: [PHP] Re-Importing .CSV file into Database
Val,
quite frankly, i'm not quite sure i know what you're
talking about. i don't think i know enum() function
: [PHP] Re-Importing .CSV file into
Database
Val,
quite frankly, i'm not quite sure i know what
you're
talking about. i don't think i know enum()
function!!
T. Edison jr.
--- val petruchek [EMAIL PROTECTED] wrote:
Hi Rick,
Thanks for the support
:[EMAIL PROTECTED]
- Original Message -
From: Thomas Edison Jr. [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 13, 2002 7:36 PM
Subject: Re: [PHP] Re-Importing .CSV file into Database
Val,
quite frankly, i'm not quite sure i know what
-Original Message-
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 10:35 AM
To: Darren Gamble
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] Re-Importing .CSV file into Database
Hi Darren,
Actually your code worked, those errors did go way by
putting
Me thinks you need to have file privileges. See
http://www.mysql.com/doc/P/r/Privileges_provided.html
-Original Message-
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
the current problem at hand of getting the :
error:Access denied for user: 'mjimm@localhost' (Using
password:
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)
**
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
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...
Take a look at MySQL-Front - its menu system talks about CSV (I've not had an excuse
to use
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
. [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
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
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
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);
The error message might be useful, but in any case I think
you need to enclose the source filename in quotes; also (you
better check the docs here) if I remember correctly you need
to give the full path to the source file unless it is in the
mysql data directory.
That's right, it needs
The error message might be useful, but in any case I think
you need to enclose the source filename in quotes; also (you
better check the docs here) if I remember correctly you need
to give the full path to the source file unless it is in the
mysql data directory.
That's right, it
24 matches
Mail list logo
