Re: Can't Load Data into Mysql Using PHP

include 'phpstudy/constant.inc'; $link=mysql_pconnect(HOST,USER,PASSWD); mysql_select_db(DBNAME,$link) or die(mysql_error()); This will give you the errors if any. HTH Jennifer "Jack" <nedcor4@nedcor.com.hk> wrote in message news:20020430055251.85053.qmail@pb1.pair.com... > 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/constant.inc'; > $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? > > > -- > Thx a lot! > Jack > nedcor4@nedcor.com.hk > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002