In article <[EMAIL PROTECTED]>, 
> Dear all
> I had a problem to get the php to load a csv file into mysql.
> I had a csv file which located at my HDD, and i had tried to Import the data
> from this CSV file into mysql using MYCC which is a console program for
> mysql, it successfully load the data into mysql table.
> Now i try to setup my webpage, which tried to perform same task is to load
> that csv file's data into mysql table, but it won't work!! don't know why!!
> here is my php code.
>   <?
> include 'phpstudy/';
> $link=mysql_pconnect(HOST,USER,PASSWD);
> mysql_select_db(DBNAME,$link);
> print ($select);
> if ($select =="HKD RATE")
> {
> $importquery= "LOAD DATA LOCAL INFILE 'C:/Documents and
> Settings/jack/Desktop/Web/test/hkd_rate.csv' into hkd_depsit1 fields
> terminated by ',' ";
> $resultimportquery=mysql_query($importquery,$link);
> print ($result);
> }
> ?>
> when i run this script, it doesn't load the data into mysql! but as i said
> before, using the same query in MYCC, i can successfully load the data into
> Mysql database.
> Could someone pls tell me what mistake i had made?

1) Is the value of $select correct so that the if statement gets 

2) If so, use mysql_error() after your mysql_query() to see if an error 
is returned by mysql.

3) Where is the value of $result coming from? Do you mean 

David Robley
Temporary Kiwi!

Quod subigo farinam

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to