perl/awk dealing with mysql. request/help

[Amzul]

hello all

i yet to start this project. i need some edvice.

i want to insert to my db

few fix words from a .txt file

what is the best language to write it? awk or perl ? i can write it in php but i know the first languages are better for this kind of job, but i am not sure of how to send the data to mysql with them

can anyone post a snippt please
the file.txt looks like that :

date spoken language time name
2007-10-24 english 20.00 name
2007-10-24 english 20.00 another_name

[numberwhun]

hello all

i yet to start this project. i need some edvice.

i want to insert to my db

few fix words from a .txt file

what is the best language to write it? awk or perl ? i can write it in php but i know the first languages are better for this kind of job, but i am not sure of how to send the data to mysql with them

can anyone post a snippt please
the file.txt looks like that :

date spoken language time name
2007-10-24 english 20.00 name
2007-10-24 english 20.00 another_name

Although you can write programs in AWK, there is no database interface in AWK that I know of. My suggestion, if you want to easily interact with a database is to use Perl. You will want to read up on the DBI module for that.

Regards,

Jeff

[Amzul]

thanks jeff but i belive i found a better way

it can all be done via mysql

so i just need to write a small script in php that create the right query. thanks for your time