Could somebody please help me with this. I cant program php or mysql but I´m in need for at script to make my life more easy :o)
I can understand if nobody wants to help me with this.. so no hard feelings.. but pleaaase.
I need some kind of php script that can parse data from a .txt file to MySql
Example of the .txt file format:
http://tekstfil.subnet.dk/tekstfil.txt
(I dont need the headlines just.:
andersen_01
andersen_03
etc..
This file is updatet almost every day and I need a script to sort the data by date (when they were added) It is almost impossible for me to spot new data when it is sorted alfabetically. (the file gets a lot bigger that this one)
So in order to sort the data by date I need this script to update the MySql every day and timestamp the new data in order to make statistic like data added [10-05-02][11-05-02] etc..
Since I´m very new at this I also need the code for the table :o)
'''''''''''''''''''''''''''''''''''
CREATE TABLE liste (
bla? bla? bla?,
);
'''''''''''''''''''''''''''''''''''