Re: Question about Load Data to mysql through php

Dear Jason Thx for the reply, but do you know where i should copy that file to in serverside? is it got to be the same directory of mysql? Thx a lot! Jack nedcor4@nedcor.com.hk ----- Original Message ----- From: "Jason Wong" <phplist@gremlins.com.hk> Newsgroups: php.db To: <php-db@lists.php.net> Sent: Tuesday, April 30, 2002 2:45 PM Subject: Re: [PHP-DB] Question about Load Data to mysql through php > On Tuesday 30 April 2002 14:33, Jack wrote: > > Dear all > > i'm a newbie in mysql, but there is one question about LOAD Data command in > > mysql, let say if i had a CSV file in client side and i want to load this > > file's data into particular table , so do i need to copy this CSV file into > > Web server side where the Mysql is or i will be able to load it from the > > client side? > > Yes, you would need a copy of CSV file on the server first. There are many > ways to get it there: > > 1) ftp > 2) scp > 3) write a simple upload page in php > etc. > > > Why i asking this, is i had a page that will load the csv file's data into > > mysql's table using php script, but when i execute this page from client > > side, it doesn't load the data into mysql, and there is no message saying > > anythin(as i don't know how to show the error message from mysql at php > > script!!). > > Someone has previously posted the required code in response to your earlier > post. > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > > > /* > Cohen's Law: > There is no bottom to worse. > */