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.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
