Discussion:
automated process
(too old to reply)
p***@gmail.com
2007-02-14 01:10:09 UTC
Permalink
Hi there,

i have a problem, and i tried to firuge out but i really need help.


I have 2 txt files with these info:


MOVIES.TXT***

"46";"CASINO ROYALE"
"48";"BABEL"


DAYS.TXT***

"JUEVES";" 8"
"LUNES";"12"
"MIERCOLES";"14"



What i want to do is load up in web server. The database is in MYSQL
SERVER. I had read about the LOAD DATA INIFILE, and is ok. I got that
part. I have 2 files so must be updated in 2 diferent tables.


My problem is because the process must be automatic. The user don't
have to see or upload any TXT file. Just click to create the TXT file,
and then these file must be uploaded and run the script that have the
LOAD DATA INIFILE.

How can I do these? I will appreciate your info.

thnx
p***@gmail.com
2007-02-21 02:02:59 UTC
Permalink
I found a way....
so if somebody needs help w/these...send a message.
Post by p***@gmail.com
Hi there,
i have a problem, and i tried to firuge out but i really need help.
MOVIES.TXT***
"46";"CASINO ROYALE"
"48";"BABEL"
DAYS.TXT***
"JUEVES";" 8"
"LUNES";"12"
"MIERCOLES";"14"
What i want to do is load up in web server. The database is in MYSQL
SERVER. I had read about the LOAD DATA INIFILE, and is ok. I got that
part. I have 2 files so must be updated in 2 diferent tables.
My problem is because the process must be automatic. The user don't
have to see or upload any TXT file. Just click to create the TXT file,
and then these file must be uploaded and run the script that have the
LOAD DATA INIFILE.
How can I do these? I will appreciate your info.
thnx
Loading...