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

I found a way....
so if somebody needs help w/these...send a message.





paulgerardo [at] gmail.com ha escrito:
> 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