php3-list | 199908

[PHP3] "Load data infile" from PHP script? From: Richard Whittaker (richard <email protected>)
Date: 08/30/99

Greetings all on the list!

I have a use (believe it or not!) for importing a user uploaded, comma
delimited ascii text file into a MySQL database, but unfortunately, some of
the settings escape me, given I have to use single quotes for certain
variable names, etc, etc... Has anyone been able to make a load data local
infile work from a PHP script?...

Here's what I have currently, and it doesn't work, which isn't terribly
suprising I guess, but it gives a general idea of what I would like to do..

$result = mysql_query ("load data local infile '$stageimp' into stage_times
fields terminated by ','");

Thanks in advance!
Richard

Richard Whittaker on the road or @ work
ICQ UIN 1390720 - You can get ICQ at: http://www.icq.com - Try it today!
WWW Homepage: http://ganges.connections.yk.ca/rwhittak
Work: 867-393-7756 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>