Re: 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. */